Print a report based on text box parameters

[bwe]

I am trying to create a report based on a table field called "ClassNo".

I would like there to be a pop up that asks for the begining and ending "ClassNo".

I am relatively new to Access - so any suggestions or ideas to create this would be greatly appreciated!

Thanks

 

[P_Henry]

You need to set up a query to supply the required details to the report. In the query, accept a parameter either from a form or from the user directly.

If the user is going to run the report directly, you can code in the criteria in the query. Use between [Enter start Class No] and [Enter ending ClassNo] for the ClassNo filed of the query. This will prompt the user to key in the start and end value.

The other option is make the parameters come from a form where the user can type in the starting and ending value. In the place where you have [Enter STart Class no], you will have forms![Forms]![frmTest]![txtStartClassNo] .

Priya

 

[bwe]

Thanks for the help. I will give it a try.
BWE