Open a FORM from Sub-Form

[jlmystify]

All,
This is my issue. I have a main form and a sub-form. In the main form i enter a search criteria and all the records that meet it are display in the sub form. This works like a charm!
PROBLEM: How do i display the full record from the sub-form into another form by just clicking on that record in the sub-form.
Thanks for your help with this issue.

 

[pbaldy]

Look at the wherecondition argument of OpenForm, which will let you restrict the form being opened to the desired record.

 

[jlmystify]

Open Form from Sub-Form

PBaldy,
Thanks for your suggestion. It worked! Now, I am able to open a form from the subform.

Thanks again.