using combo box

T

Tata2004

Hello everyone, anyone can help me?
I have 2 tables in my access database. TABLE 1 has 10 fields. TABLE 2 has
3 fields. These 2 tables are link already. The first field in my TABLE 1 is
a combo box that successfuly listing the data in field one of TABLE 2

SELECT [AccountID], [AccountNo] FROM Accounts;
2
0";2"

What will I do in order my two other fields from TABLE 1 display the data
automatically from TABLE 2 once I selected the Account Number? I want to
display automatically the Account Name and Account Address from TABLE 2.

Thanks for the assistance.

TDC
 
Top