Pop up Form instead of Subform

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

Guest

I have a form containing a subform. Hence, when I click on a particular field (Session Date) on the main form, the related records appear in the subform which I can scroll through and add/amend, etc.. Rather than have the subform visible , I want to have a button the main form to open a pop up form which still contains the same set of records . When I do it, the pop up form shows the all the records in the underlying table rather than the filtered group of records which appear in the original subform. Does this make sense to anyone? I'm a novice, so please keep it simple.
 
Try changing the DoCmd.OpenForm statement that opens the
pop-up form to include a Where parameter e.g.

DoCmd.OpenForm "yourPopUp",,,"[SessionDate]= txtSessionDate]"

You will have to change yourPopUp, SessionDate and
txtSessionDate to suit your app.

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
I have a form containing a subform. Hence, when I click on
Click to expand...
a particular field (Session Date) on the main form, the
related records appear in the subform which I can scroll
through and add/amend, etc.. Rather than have the subform
visible , I want to have a button the main form to open a
pop up form which still contains the same set of records .
When I do it, the pop up form shows the all the records in
the underlying table rather than the filtered group of
records which appear in the original subform. Does this
make sense to anyone? I'm a novice, so please keep it simple.
 
Back
Top