how do I pass a subform's field to a query that a new form is based on

  • Thread starter Thread starter DJ McNeill via AccessMonster.com
  • Start date Start date
D

DJ McNeill via AccessMonster.com

Hi,

I have found a note on how to pass a forms field to a query.

[Forms]![Form Name]![Control Name]

But how do I pass a subform's field value to a query.

I tried [Forms]![Sub form name]![Control Name] that didn't work (I think
because the query didn't think the sub form was open)

Can some one help me out?

Thanks
DJ
 
figured it out:

[forms]![Form name]![sub form name]![control name]
 
Back
Top