Displaying Data from a related table

[SimonSez919]

Hello,

I have a form based on 1 table and I am trying to find out if I can display data from another table if I have a relationship between the 2 tables?


Thanks

 

[ListO]

If your form is based on a table, it's more difficult than if your form is based on a query.

Try this:
1. Create a query which calls up all the fields in the table on which the form is now based. You can bring the fields from the second table into that query, linking the tables together with whichever field is common to them. Close it and save it.

2. Open the form in design view, double-click on the little box in the top lefthand corner, and click on the Data tab of the Form Properties window. Change the Record Source to the query which you've just made, which now links your form to the query instead of the table, and that should do what you desire.

Good luck.