SQL Query with subForm??

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

Guest

Situation: A have designed a form "Form1" which includes a subform
"SubForm1A" and this includes another subform "SubForm1B" For the
"SubForm1B" I have created a SQL-Query, which only contains records in case
that the a record field is equal to a SubForm1A.recordset.

But HOW can I address this field?

SELECT tblTest.* FROM ... WHERE tblTest.anID=Forms!subform1A.bID

This query does not work because Access believes "Forms!subform1A.bID" is a
parameter instead of subForm1B Field.

What am I doing wrong?
bID..is a recordset field of subform1A
 
Subforms don't exist in the Forms collection. Try this:

WHERE tblTest.anID=Forms!Form1!subform1A.Form!bID
 
Back
Top