Printing report based on query in switchboard- user friendly

[Newbie456]

Hi -

I have a report based on a query that prints box labels. Basically, it looks in the database and prints all items in each storage box. It's based on a query where I input the specific box number I want in the criteria. Simple.

What I would like to do is build a function in my switchboard that asks the user which box number they want printed when they click "Box label." I'd like to make it so users don't have to go into the query and input it. Many of my coworkers have access-phobia.

Any idea as to how to do this?

Thanks!

 

[fneily]

Make your query a parameter prompt. On the criteria row, under the field for "box number", inside square brackets [ ] place your prompt.
eg. [Please enter a Box Number]

 

[straybullet]

Have the switchboard button open a form which has a textbox for entry of the box number and a button to "view report"
Have the button on the form "run" the report.
In the query, have the criteria set to something like
Forms!SelectBoxNumberFrm.BoxNumTxt
When the button to view the report is clicked, the query will run, find the criteria needed in the textbox on SelectBoxNumberFrm and the report should open with the desired information.

Let them hate - so long as they fear... Lucius Accius