Dbl Click on subform to open form

[Johnny Drama]

Hello all,

I've got a form with two subforms in it. The main form is named frmReports and the subforms are frmExeceptionsSub and frmResponseSub. When the main form is opened the Exceptions subform will pull in all records relating to the Report identifed in the main form, and the response subform will show a single response for an exception. If I click on a different exception in the exception subform the response subform will automatically update with the proper response.

What I would like to do is allow the user to double click on the response and have the subform open up as its own form, allowing the user to update the information as needed. I've been able to get the subform to open into its own form without a problem, however the data pulled into the form is not the data associated with the record in the main form/Exception subform, it's simply the first record in the table that the response subform is attached to.

Any thoughts on how I can get the correct data into the response subform when it's opened as its own form?

Thanks in advance.

Access 2007

 

[VilaRestal]

It would be the same as this but on the subform's Detail's (and probably each of the subform's control's) DoubleClick event:

http://www.access-programmers.co.uk/forums/showthread.php?t=210953

I'd recommend finding and downloading the demo database I made for that in the thread

 

[Johnny Drama]

Awesome. Worked like a charm. Thanks!