form from multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created 2 tables in Access. Subsequently I've created a form based on
the information in the first table. I want to add a field into that form
from the second table. I'm not sure that I'm doing it correctly -- further
note, the particular field that I want to retrieve from the second table
happens to be a list box.

I would like my form to capture the value that I've chosen in the list box
and automatically put it in the new field that I'm creating on the form.

Can anyone help -- I sort of new to Access and I'm completely stumped...
 
Hi,
I will assume your 2 tables are related somehow.
Create a query that pulls the fields you want from both tables
and make that the Record Source of your form.
You do this by selecting the query from the dropdown on the form's
property sheet that appears when you click in the RecordSource property.

By the way, a table field cannot be a list box. A list box is a control that you add
to a form that will display data from a table.
 
Back
Top