Combo Box Updating

[Guest]

Microsoft Access 2002
Someone with no programming experience.

I have a form that contains contact information for customers and all data
is pulled from a table called 'Customers'.

The way I want it to work is so that if under the "CustomerID" combo box
when a customer is chosen, that all the text boxes on the form will change to
reflect the information associated with that CustomerID from the 'Customers'
table.

Also, if all these boxes are updated, if I change information in one of
those text boxes will it update the information in the 'Customers' table
based on the "CustomerID" I chose from the combo box?

Thanks in advance!
-Dan

 

[Chris L via AccessMonster.com]

The combo box you use to Find a record can not also be used to store data. So
you need to add a new combo box to your form from the Toolbox (make sure the
control Wizard option is selected). This will start the Combo Box Wizard -
choose the option "Find a record ..." and follow the instructions.


hth

Chris