Reports

[edmel1]

I am trying to create a button that when pressed would ask the user for parameters for the report (i.e. Report by date( enter date)). I know I can use the Open report macros, but is there a sub macros that will ask for parameters?

 

[burrcm]

Provided the report is based on a query which has user parameters included, the parameter box will appear when you click the button to open the report.

Chris B

 

[edmel1]

The report builds upon data entry, so when you enter a new record, and print the report, all records show including the new one. What I would like to happen is when I click the button (to run/ open the report) I am asked for parameters. I would love if I could have a multi choice list box which I could pick the parameter I wanted, then specify. I am very new to Access, and I do appreciate any help I can get.

 

[ted.martin]

Does this help?
http://www.access-programmers.co.uk/forums/showthread.php?t=141930

I appreciate your query is not a crosstab but is the solution to use a pre-filter and Me.Tag