Combo box and synchronizing with records

A

Airboy

I have a field called Equipment # on a form with other related fields from an
Equipment table. I would like to choose a value from a combo box showing
these Equipment #'s, and have it synchronize the other fields to the record
in the table for the selected Equipment #.
 
K

Ken Snell [MVP]

Use the combo box wizard to add a combo box to the header of the form; tell
the wizard that you want to use the combo box to find a specific record in
the form.
 
A

Airboy

I had tried this, but when I try choosing a specific Equipment # from the
list, it won't let me choose any, and thereby won't refresh the other fields
to the selected Equipment #. I must be doing something wrong with a property
settings perhaps? I am by no means an Access expert, which is obvious.
 
K

Ken Snell [MVP]

The control source of the combo box must be empty. Be sure that there is no
field name listed there.
 
Top