Creating a Pop-up form for a report

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hello everyone,

I have a situation where we have a report that many
different people use. Due to the nature of the information
they use, I am trying to figure out how I can create a
prompt upon the report opening that allows them to see
exactly what they want. By the way, they would all select
by the same field.

For example, one department wants to see if a particular
report as been completed. They just want to see that
report not the other 50 that were completed in the last
day or so.

By the way, I am using Access XP in a Windows 2000
environment.

John
 
Create a form that has controls for the data you want to see. Open this form
in the report's Open event using the acDialog window mode argument in the
DoCmd.OpenForm call. This will pause the code until you close or hide the
form; however, to read the information selected on the form, it needs to be
open. Once your selections are made, click a button on the form to hide it
(Me.Visible = False) and the report will continue to open. You can have the
report or the query feeding the report refer to the information on the form.
Remember to close the form when you close the report.
 
Back
Top