Form Help

[chaddresnick]

I created a very basic form. I have three fields: customer number, customer name and customer status. I made the customer number a combo box. I want the other two fields to change to display the correct information when you select (or enter) an existing customer number. The combo box does not allow for new customer numbers to be entered, just existing ones.

Right now, when I change the value in the customer number, the other fields do not change. Am I missing something?

[Rawb]

You will need to use VBA code or a Macro to change the other fields each time a new value is selected from the Combo Box.

Try taking a look at this link and see if it helps: http://access.mvps.org/access/forms/frm0058.htm