Combo Box/Form

[sunnygirl]

I am attempting to setup a user form to add/edit customer data. I have created a combo box to select existing customers to edit. Once I select the customer I want to edit, it returns the value (custID in this case) to the appropriate field.

The probelm, the other data is not being returned to the other fields. For instance, customer name, address, phone, etc. is not being pulled into the fields. The text boxes are holding the data from the very first record in the combo lookup box.

I hope this makes sense to someone. It's hard to describe in words.

Any help is appreciated. (I would like to enjoy the beautiful weather outside here in Daytona Beach, Florida... )

 

[Rich]

Put the combo in the form header, use the combo box wizard and select find a record on my form from the available options

 

[sunnygirl]

Ohhh thank you so much... I was getting very discouraged.

Put the combo in the form header, use the combo box wizard and select find a record on my form from the available options