Field Auto Fill In

[Guest]

I have a database base on only one table. What is the easiest way to enter
the customer name in one field and have their address automatically fill in
for the 3 address/contact fields.

 

[John Vinson]

I have a database base on only one table. What is the easiest way to enter
the customer name in one field and have their address automatically fill in
for the 3 address/contact fields.

ummm... why would you WANT to do this?

You should store the name and address, once and once only. Having the
address fill in a second record is redundant.

You can use an unbound Combo Box selecting the customer's name to
*navigate* the form to that customer's record. But you should
certainly not enter that data into a second record! Use the combo box
wizard, and choose the option "find a record".


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

I am actually only entering the address once, but I have sometimes multiple
records with the same owner. I probably didnt explain myself correctly,
sorry. I am looking to auto fill in the address if the owner already exists
in the database. I will try your suggestion. Thank you!!