MS-Access: What could cause one form with a join query to load right and another not?
- by Daniel Straight
Form1
Form1 is bound to Table1. Table1 has an ID field.
Form2
Form2 is bound to Table2 joined to Table1 on Table2.Table1_ID=Table1.ID
Here is the SQL (generated by Access):
SELECT
Table2.*,
Table1.[FirstFieldINeed],
Table1.[SecondFieldINeed],
Table1.[ThirdFieldINeed]
FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.[Table1_ID];
…