Selecting a record

[Dennis]

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

 

[Golfinray]

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