Combo box and synchronizing with records

[Guest]

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 #.

 

[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.

 

[Guest]

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.

 

[Ken Snell [MVP]]

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