I have a query which is run in a subform... however, I need a value from the parent form.
How do I link to this value in the parent form?
The query should look like:
SELECT tbl2.name, tbl.number
FROM tbl1 LEFT JOIN tbl2 ON tbl1.aID = tbl2.aID
WHERE tbl2.aID = parentform.[aID]
Now, the question is about the WHERE clause... how do I link to the parentform?
any help is appreciated
Jazz
How do I link to this value in the parent form?
The query should look like:
SELECT tbl2.name, tbl.number
FROM tbl1 LEFT JOIN tbl2 ON tbl1.aID = tbl2.aID
WHERE tbl2.aID = parentform.[aID]
Now, the question is about the WHERE clause... how do I link to the parentform?
any help is appreciated
Jazz
