Auto-Fill Form

[Sketchin]

Hey everyone,

I have a form based on an Invoice table and would like to have a combo box where someone chooses a company name, and have the address, phone number...ect update accorrding to which company is chosen. I have a table for Companies and a table for Invoices, which contains a one to many relationship to CompanyID in the companies table.

I can get this to work when I type in company ID, but cannot get it to work with company name.

Im sure you will need more info than this, but if their is a short answer, I would love to hear it!

Cheers

 

[pbaldy]

How about:

http://www.baldyweb.com/Autofill.htm

 

[Sketchin]

pbaldy, I seriously can't thank you enough. I've already spent 2 days trying to figure this mess out, and you solved my problem in 1 minute! If we were friends, I would buy you a bottle of wine!

Cheers!!!

 

[pbaldy]

We ARE friends!! I like nice red wines.

Happy to help!