Simple combo box question

[laqa]

Hi, I want to make a Form with a combo box listing customers and in the right side, customer details. So when I choose one customer, his details show up. My Form is OK, but only with navigation buttons. I am a professor and my subject is the relational model, normalization and all, so I need something simple, just using MS Access standard tools, without any VB code.

Thanks,

Luis.

[RuralGuy]

The ComboBox wizard know how to make a ComboBox that can "Locate a record" in your RecordSource assiming you have bound your form to a table/query.

[laqa]

Thanks, but the wizard lets me search for the attribute Name, lets say, but it does not link to the other attributes like address, etc. that are in the text boxes in the right.

Thanks,

Luis.

[RuralGuy]

Are you displaying all of these fields on your form?

[laqa]

Yes, I would like to know how I can list Customer details (same table as customer name in combo) in the right on a form.

Thanks again.

Luis.

[RuralGuy]

If you move to that record does all of the fields you want display on your form? The ComboBox can move to any record you want.

[laqa]

If I make a form, with navigation buttons, I can display all the information, Name, Address, Phone, etc for every record. What I want to do is move to another record using a Combo Box displaying Name (or any other field) instead of the usual navigation buttons of the form. The form would have one Combo Box to move records and Text Boxes for the other fields of the record whose Name was chosen in the Combo Box.

Thanks again.

Luis.

[RuralGuy]

The "Navigation" ComboBox would be unbound. On that same form you described where the Navigation buttons work, let the ComboBox wizard create the "Navigation" cbo for you by selecting option #3.

[laqa]

WOW! Thanks a lot.

[RuralGuy]

You're certainly very welcome. Glad I could help.