link combo box to form in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 & "'"
 
Back
Top