create form from 1 table, with a lookup result to another table

[khanhhuyen7997]

Hi,

I am making a form with the use of 2 tables record.
In table A, I have Rejection_ID, Supplier_ID.
In table B, I have Supplier_ID and other Supplier_Contact details.

In the form I make, I will create a rejection with Rejection_ID and Supplier_ID.
I want to see all Supplier_Contact in a textbox after entering Supplier_ID.



How can I do this?
Using VBA code? what should it be?
or do we have smt easier without using VBA?

Cheers, Huyen

[pbaldy]

Like this?

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