Run query from Subform without Parameter Value box appearing?

[BigRods]

Hi,

Hope someone could help, bit of a newbie to Access...

I have a form (frmMain) with subform (frmDeath). The frmDeath subform has a Death_ID text box.

What I want to do is create a query that when a button is clicked, it displays the subform data on a new form. I have the query criteria as:
=[Forms]![frmDeath]![Death_ID]

However the problem is when running the query when in the frmMain form I get the "Enter Parameter Value" box up.
If I just open the frmDeath subform up it works fine but I guess Access doesn't recognise the frmDeath form as being open from the frmMain form?

Is there any way for Access to recognise the frmDeath form as being open from the frmMain form?

Many thanks!

 

[BigRods]

Got it working - I was using a Navigation Control for the sub-form and changed the criteria to:

[Forms]![frmMain]![NavigationSubform]![Death_ID]

Easy when you know how!