From one form, opening another form and finding matching data
Posted on 2011-09-21
I have a form and subform. The subform has a button to open another form and find the record with matching id. The macro behind it is "1AWorksAddressfrm, Form, , [worksID]=[Forms]![1acontactsubfrm].
If I click this button on the subform I get a dialog box - Enter new parameter - [worksID]=[Forms]![1acontactsubfrm]. I then have to type the worksid in, at which point it opens correctly.
However, If I open the subform independently, the button works perfectly and goes straight to the matching record - no dialog box, no typing.
Why? What do I need to do to make it work in the subform mode, as that is where it is needed?