I have created a form that accesses a table. This form should allow a new record to be added or to update and existing record. How do I select a record from a list of all opportunities in the table or add a record if that is the intent? Should I create another form that has a drop-down control and then open the main form? Thanks. Dennis
Put a combo box on the form (use the wizard to do that and allow the wizard to set the source for you.) Right click on the combo box, and under events, click afterupdate. Click the little button out to the right and start the code builder and type: Me.filter = "[id or whatever you want to use] =""" & me.combo# & """" Me.filteron = true The combo box number will be listed, like combo 12 or combo 43 "Dennis" wrote: > I have created a form that accesses a table. This form should allow a new > record to be added or to update and existing record. How do I select a > record from a list of all opportunities in the table or add a record if that > is the intent? Should I create another form that has a drop-down control and > then open the main form? > > Thanks. > Dennis
