Basing a form on a query

[jasn_78]

Hi
I know this is a really easy question I am just having a mind block at the moment so I was wondering if someone could remind me on how to have a text box updated each time I change a combo box on the same form
The e.g being if I change the address through a pop-list how do I make it change the customer's name

Thanks

 

[David R]

Are you trying to lookup an existing record based on the address? Use the Combo Box wizard and select the third option, Look up the value in an existing table or query.

HTH,
David R

 

[Travis]

Place your code in the AfterUpdate Event.