Auto Populate a box

[swan717]

Hi:

I'm trying to create a database that will automatic populate a field when I enter something in the prior field. For example, the table has the following four columns: vendor, address, town, and date of service. The vendor's contact address and town will always be the same, so I want to have a combo box to list all of the vendors and then automatically populate the address and town fields. Is this possible?

Thanks in advance for your help!!!

 

[bluedragon2]

One way to do this is to have a sheet with a table of your vendors and their addresses.(Col A vendors, Col B Address, Col C town) So lets say on Sheet 2, you have that list and you define a name to that list called vendors.

On sheet one, in cell A2, you type in the vendor.

In B2, put =VLOOKUP(A2,vendors,2,0)

In C2, put =VLOOKUP(A2,vendors,3,0)



Blue

If I wasn't Blue, I would just be a Dragon...

 

[swan717]

Thanks for the tip, but I'm not really sure how to apply it to Microsoft Accss. Any suggestions?

 

[bluedragon2]

Sorry, I was assuming that you were using excel...

That's what I get for that...

If you are creating a form to do this, it can be done...I haven't used access in a long time, but maybe an Access guru may be able to help you out. There are also some Access forums on the site that may get you a quicker answer.



Blue

If I wasn't Blue, I would just be a Dragon...