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!
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!