Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

output in report

Status
Not open for further replies.

jgeneie

Technical User
Feb 20, 2002
41
0
0
SG
hi all,
i am practical new to access....so bear with me for a moment

I have created a criteria search form and the output is displayed in a report format by using a macro. In this criteria form, i have used country, customername and companyname as the search properties.

but because my report has details like telephone no, address, email address.....when i click the OK in the criteria search form,it will pop out a "enter parameter value" box for me to input the value of these properties

how to i get rid of the "enter parameter value" box

thanks
pleas assist
 
Does the query you're basing the report on have a parameter set up in it? If so, that's where the box is coming from. You can check this by going into design view of your query. Then select Query from the menu bar, then select Parameters.

If not, make sure that all your fields in your report are also in your query.

These are the only 2 things I can think of right now.

Good luck!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top