Open form based on Mainform and Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Is it possible to open a form based on a main form and subform?

I have a main form with a subform (in datasheet view) and I need to have a
third form pop up when the user clicks in a field in the subform (this field
is a memo field) and the new form that pops up will allow the user to view
all of the text in the memo field (as in datasheet view this field is small).

How do I get the pop up form to display the PrimaryID from the mainform and
the correct record from the subfrom?

I know I can use the OnClick in the subform and the OPenForm to open the pop
up form, but I can not get it to display the correct info from the mainform
and the subform (I can just get it to display the info from the subform, it
does not update with the ID from the mainform).

Thanks

Thanks

Brian
 
The solution is simple.

Just reverse the sub-form layout.

You will have the "main" form with the memo, and perhaps a date field, or
whatever. To display the primaryID information, just make a sub-form.
 
Back
Top