Generating Report from Form

[mwabbe]

I want to have a form with two combo boxes on it. one for Employee. another for (info, ben, training, emergency contact, discipline).
and then have a report made just for what i select.



is this possible? thanks

[pbaldy]

Presuming you mean to open an existing report filtered to the selections made, this technique would be one way:

www.baldyweb.com/wherecondition.htm

[mwabbe]

when i select the name and report i want to filter how do i make it open up the report i selected. using that technique wouldnt i have to code in which one would open by name? if its selected in the combo box. the name would change.

[pbaldy]

If you're using a combo to let the user select the report:

DoCmd.OpenReport Me.ComboBoxName...

[mwabbe]

New Question. Still on the same subject. I currently have two combo boxes: one cboEmpName, cboRepName. they show all names and rep names in the db. the reports get data from the queries and so now i was wondering if it is possible to set a the criteria of the filter to the name chosen in cboEmpName and requery the open the report so that it will only be of records for that employee

[pbaldy]

Depends on the view. The new "Report" view in 2007 can be requeried. Preview is static.

[mwabbe]

thanks pbaldy for sticking with me. i got it working how i want it .

[mwabbe]

not yet i guess. how do i change it so when i click the button to open it, it will just open it and not print it right now it prints it.

[pbaldy]

Look in VBA help at the arguments available for OpenReport. One of them determines the mode it opens in. You want preview, but the default if unspecified is printing out.