Cell Selection in Subform

[MikeEller]

Hello Forum,
I have a form with a subform. The subform was created with the form wizard and displays data from a specific table.
What I want to do is:
when the user clicks in a specified cell in the subform table (the "Remarks" column), I want that click event or focus event to display another form. The second form will display text data from another table. Which data is displayed depends on the row index of the table in the subform that user has selected.

Can this be done?
If so, how?

Thanks,
Mike

 

[MikeEller]

OK,
That makes sense to me. One last question...
Can I capture the user clicking into that grid as a click event or focus event? If not, how do I initiate the opening of the other form? I would like to use the click event if possible.

Thanks for the insight and push in the right direction.

Mike

 

[mresann]

Incidental to this discussion, I have come across a website that should clarify the correct code to access variables, controls, and recordsets from parent forms to subforms, and vice versa. This should alleviate a lot of frustration.

Correct Subform Coding Procedures