Got report generating, but get an input prompt popping up.

C

chibi_vb

Before the report generates, a prompt called "Enter Parameter Value" pops up.
This was a checkbox on my user input form that helps generate the report.
How do I keep this prompt from coming up?
 
M

Marshall Barton

chibi_vb said:
Before the report generates, a prompt called "Enter Parameter Value" pops up.
This was a checkbox on my user input form that helps generate the report.
How do I keep this prompt from coming up?


Make sure the form is open before opening the report.
 
C

chibi_vb

What do you mean by the form being open? The input form takes the info after
a button is pressed, and opens a report using DoCmd.
 
C

chibi_vb

Discovered the problem, accidently renamed a field in my SQL statement with
underscores instead of using [].
 
M

Marshall Barton

Since you did not explain the arrangement of your forms, I
assumed you were using the common approach of having the
input text box on the form with the button instead of as a
separate form. The most common problen then is that the
form was closed.

Regardless of all that, it's good that you found the
problem. However, I feel compelled to say that it is a poor
practice to have names with spaces or other funky characters
that require brackets.
 

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

Top