Open Sub Form linked to Same Record as Pop-Up?

[sunilkeswani]

How do I have another form open up, which is linked the the same record
in the previous form?

i.e

Field1 Field2 Field3 will be on Form 1 And

Field4 Field5 will show up on another pop up form, which will still be
stored in the same record as my previous form.

This I am doing because the fields are big memo fields, and the form
looks too big.

Any help would be appreciated

Cheers
Sunny

 

[Marshall Barton]

How do I have another form open up, which is linked the the same record
in the previous form?

i.e
Field1 Field2 Field3 will be on Form 1 And

Field4 Field5 will show up on another pop up form, which will still be
stored in the same record as my previous form.

This I am doing because the fields are big memo fields, and the form
looks too big.

Presumably. one of those fields is the table's primary key.
If so, then open the other form using the OpenForm method's
WhereCondition argument to filter the other form to the
specific record:

strWhere = "pkfield = " & Me.pkfield
DoCmd.OpenForm "otherform", , , strWhere

 

[sunilkeswani]

Thanks Marsh,

This helps

Regards
Sunny