View Full Version : Basing a form on a query


jasn_78
12-25-2001, 03:04 PM
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
12-26-2001, 07:29 AM
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
12-26-2001, 11:42 AM
Place your code in the AfterUpdate Event.