Opening a form from within a form

[Guest]

I am trying to make it so that when you dbl click in a field on a form
another form opens displaying the contents of that field so they can be
editted. I can get it to open the form when the field is dbl clicked, but I
cannot get it to display the contents of the field that was clicked.
Can anyone help? I am kind of thinking that I need to use a query somehow,
but not sure how to get it to refer to a form and the active records
reference.

 

[Guest]

Chris,

You did not indicate what the record source for your second form is.
Assuming that the record source for the second form is producing a record set
that contains the record you want to be displayed, use the Where parameter
with your OpenForm call.

In other words, add a Where statement to the code that is opening your
second form. Look in the Help file for OpenForm.