link combo box to form in Access

C

c.d.

I have a combo box that provides a drop-down listing from my table. When a
user clicks on a particular record in the box I need the data entry form to
open ,populated with the selected record, to allow for editing of that
record. Thanks in advance for any help you may provide.
 
O

Ofer

On the after update event of the combo box you can write the command line to
open the second form, filtering on the data selected

' If the combo field type is Number
docmd.OpenForm "FormName",,,"FieldName = " & me.ComboBoxName

' If the combo field type is Text
docmd.OpenForm "FormName",,,"FieldName = '" & me.ComboBoxName & "'"
 
Top