Automatically enter data in form fields.

[egptech]

I have a table of customer names and info. I want to be able to enter the customer's name in the name field of a form and have the address, city, zip, tel. etc. fields automaticaly filled in with the customer's info. I am suffering from severe brain fade on this one. I pretty much have everything else working in my database but this one is killing me.
I am using access 2000.
Thanks

 

[zishan619]

Hi:
Use a DLOOKUP statement in the afterUpdate event of the textbox Name. It should fill in all the textboxes that needs to be filled.
Cool
Z

 

[hwkranger]

you can do this a number of ways.

-use a dlookup as the datasource for each text box.
-use VB to pull the record of the customer and then change the .value of those controls to reflect the information based on the customer name.
-use bounded controls
-use a filter that uses customer name

There's probably more, but that's off the top of my head.

Randall Vollen
National City Bank Corp.