Linking a Specific Subform Record to Another Form

[Guest]

Hello,
It's been a while since I created databases in Access and I am a little
rusty. I have a form with a continuous subform. Within the subform, I have a
button tied to a macro where the "Where Condition" reads
[subform_id]=[Forms]![subform_name]![subform_id].

When I run the macro from the subform within the main form, Access asks for
the Parameter Value. When I run the macro from the subform open by itself, it
runs beautifully.

I am chasing my tail. Any assistance is very much appreciated!!

Thanks,
~ Chris

 

[Steve Schapel]

Chris,

The [subform_name] form is not open, it is merely being displayed via
the avenue of the subform control on the main form. Therefore, Access
is unable to evaluate [Forms]![subform_name]![subform_id]. You will
need to do like this...
[Forms]![MainForm]![subform_name]![subform_id]
....or, as some would have it:
[Forms]![MainForm]![subform_name].[Form]![subform_id]