query

[Guest]

i have two forms. the first one (addresscode (autonumber) and address(text)).
the second one (id(autonumber), Name(text), Surname(text),
Addresscode(number) and address(text). I create two forms one for each table.
In the second form i create it using the second table. How can i input the
addresscode and display me automatically the address in the second form?

 

[Guest]

I did this but i dont know how to input the address code in second form and
automatically display me the address.