Help with PopUp Print Form

  • Thread starter Thread starter IreneJ
  • Start date Start date
I

IreneJ

I have report that I would like to have subreports on and
have them all run for a specific date range. I put the
[Forms]![frmPrintDialogueBox]![txtBeginingDate]
and ...end date in the criteria line of the query. I
built the form with the two boxes on it and attached the
form to the On Open in the report. My problem is that
when I click on the report the reports shown behind with
#errors and the print dialogue box comes up and lets you
enter the dates but doesn't seem to get back to the
report through the query so nothing happens. Can you
tell me what I'm doing wrong. Is there supposed to be
something else like a macro or something.

Thanks so much,
IreneJ
 
Irene,

I read your question when I posted my question. I usually
use the form to print the report. In other words, I pull
up the report, add the data I want (in your case dates)
and then have a button on the form that is set to print
the report. It's never failed on me.

Just thought I would try to help.
 
I usually create a query and put [Enter date] in the
critera to select the records. In your case int would be
between[Enter Begin Date]and[Enter End Date]. Once the
query is working, then I have the report point to the
query. Works for me! if you want the report from a form,
just add a button pointing to the report.
 
Back
Top