Correct criteria syntax for third level subform??

[bddewell408]

I know :
=[forms]![frmName]![fieldname] - active form
=[sfrmName].[Form]![fieldame] - subform

what is the correct criteria for a subform on a subform on a form?

also, I need it to be a like statement as well, similar to an active form version of

Like [forms]![frmName]![fieldname]&"*"

Thanks
Bryan

I would be lost without this website and group, they don't teach stuff like this in classes that I have taken.

 

[ZmrAbdulla]

http://www.mvps.org/access/forms/frm0031.htm

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[PHV]

Another helpfull link:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886