Question Simple Question about Multiple Table Queries

[Access_Headaches]

I am very new to this so please don't mind my ignorance. I have a database with 2 Tables, 3 Queries, and 3 Forms. I just went into design view for query 1 (which pulled info from Table 1) and added table 2 (Show table, Add). The problem is, once I open Form 1 which pulled data from query 1; the form is blank. When I go into design view of Form 1, I see the data from table 1 and 2 which is what I want. So my question is: How do I see the detail of my form without removing table 2 from query 1?

 

[jdraw]

What have you tried?


You may find this site helpful
http://www.sfubusiness.ca/areas/mis/tutorials/2np/lessons/map.pdf

 

[vbaInet]

When you go to design view and open the query via the Record Source property?

Ensure that the Data Entry property (which is under the Data tab) of the form's Property Sheet is set to No.