when I close a form of a report the blank report opens

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

Guest

i am a beginner. so please excuse me for my ignorance...

I have created a query which gets its parameters from a form. Now I have
created a report based on this query. When I open the report, the form
appears as reqd. But when i just close the form without entering the
parameter values, the report prompts for the parameter values and a blank
report opens.....

How can I avoid this???

Thanx in advance
 
You can put code in the Onopen event of the report to check if the form is
open, and if it's not, prompt the use with a message and close the report

If Not CurrentProject.AllForms("FormName").IsLoaded Then
MsgBox "FormName is not open"
Cancel = True ' Close the report
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rerun query 2
Reference controls on a dialogue form as the parameters 1
Report, Paremeter, Form issue 3
Opening a paramater form when open a report 1
Custom Parameter Dialogs for Reports 2
Report Input Parameters 2
Access Access Report Works on One Machine but not Another 3
Entering Report Parameters through a Form 2

Back
Top