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 & "'"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box Problem 5
Combo Box Selections 1
New records don't display on form with combo box 1
Macro doesn't work first time form is opened. 2
Making all controls match selection of combo box 0
Using Combo Box in a Form 2
Access Form with Combo box 5
Requery Combo box in popup form 2

Back
Top