How do I make an editable subform a pop-up

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

Guest

I would like to open a subform as a pop-up that is editable and that remains
linked to the current record of the mainform.

I have got it right to do this to the extent of being able to edit any
record in the subform that exists in relation to the mainform. However, when
going to a new record in the subform, the link is lost. (This also happens
when there is no record in relation to the mainform's record in the subform
and I wish to create such a record). Although I am able to type in the link
number - [CaseNo] - the risk is that I may inadvertantly type in the wrong
number and then have to search for my misplaced info.

The mainform is named "Cases" and the subform "Progress" with the fields
[ProgressID], [CaseNo], [ProgressDate] and [InterimProgress] - a memo field -
in the subform. The tables "Cases" and "Progress" are linked by the field
[CaseNo], which is the Primary key in "Cases".

The reason I want to do it this way is because the mainform contains too
much info and it is easier to manage progress through a pop-up.
 
Kevin,

Just an ide, I haven't tried it, but maybe you want to give it a shot: set
the Default value property of the CaseNo control in the subform to:
=Forms!Cases!CaseNo
That should default in the current CaseNo in new records.


HTH,
Nikos
 
Back
Top