SubForm Query

[L0stAngel]

Hello, I have a form that has a subform on it. When I push a cmdButton on the subform, it opens a report. This report is tied to a query in which it gets data WHERE MunID = subform.txtMunID.text...how can I put this WHERE statement in a query? I've tried

WHERE MUNID = [forms]![subform]![txtMunID]

but it always shows a popup when the report opens asking for what [forms]![subform]![txtMunID] is. But, if I don't go through the main form, and just open the subform and push the cmdbutton..everything works good. This makes me think it has something to do with being a subform in a normal form...

 

[Remou]

Hi
A subform reference usually looks something like:
Forms![MyFormName]![MySubformName]!MyField

PS I am not sure if this has been posted in the right forum, you could look in the Access Forms Forum.

 

[PHV]

WHERE MUNID = [Forms]![main form]![subform control].Form![txtMunID]

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

 

[L0stAngel]

Thank you guys.