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

--
Message posted via http://www.accessmonster.com

figured it out:

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

--
Message posted via http://www.accessmonster.com

Try:
[Forms]![Form Name]![Sub form name].Form![Control Name]

For an explanation see:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DJ McNeill via AccessMonster.com" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> 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?