parameter report from list box with print option?

[ISTodd]

Hi,
I'm rather new to this....

I have a standard class list printing from a query. Is there any way I can have the user define parameters based on [teacher name] and/or [grade] at one place on a form (list box)?

Then having the option of the user printing that specific report?

Thanks for any help you can offer... Todd

 

[misscrf]

sure you can. Just create a form with the two list boxes, and a command button that will use those parameters to satisfy the cooresponding report's parameters, and to print ( 2 sections of code - 1 fills parameters, 1 prints)

you will probably need to look up the part on the parameters, Access help will have instructions on that.

Then your only step is setting up that form to open as you like, ie from a main menu or what ever you want.

misscrf

Management is doing things right, leadership is doing the right things

 

[bitmite]

make a form witht he two list boxes then on a OK or print report button on the form have something long this lines

Private Sub Command87_Click()
 DoCmd.OpenReport "Plates Summary", acViewPreview, , "teacher name = 'john'"

this will open the report and filter out only the data whee the teacher name is "john"


Brought to you By Nedaineum
The Portal to Geek-tum