Auto Fill in Contact List

[kleivakat]

I'm creating a vendor contact list using a standard Access contact template
and revising one of the forms. I have several people from one company, and
I'd like to have Access fill in the address fields if I type in the same
company name that I already have entered.

How would I set up the form to do this?

KK

 

[Gina Whipp]

kleivakat,

Without knowing more about your form... I would suggest looking into Combo
Boxes. Use the wizard and select the one that says 'Find records based on
my selection' (or something to that effect. Use it for Company Name and
then when you type in the Company Name it will find the address for that
Company provided they are in the table.

Now, if you plan on also adding new from the same form you will also need a
txtCompanyName text box OR you can write a little function to add to list
for the Combo Box eliminating the need for the additional text box. (There
are plenty of examples here on how to do that should you choose that route.)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm