Display data from 2 tables in one form

[DH010010]

i have a form that displays and alows me to edit data in table 1. Now in this
form I have a drop down box which displays contacts from table 2. once i
select the contact i want there details to be displayed in the form. how do i
do this?

 

[Ken Sheridan]

For the form's RecordSource use a query which joins the two tables and, in
addition to the columns from the first table, return whichever columns you
want from the second table. You can then bind text box controls on the form
to those columns. If you don't want users to be able to edit the data from
the second table in this form then set the Locked property of the controls
bound to those columns to True (Yes) and their Enabled property to False (No).

Ken Sheridan
Stafford, England