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
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
Presuming you mean to open an existing report filtered to the selections made, this technique would be one way:
www.baldyweb.com/wherecondition.htm
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.
If you're using a combo to let the user select the report:
DoCmd.OpenReport Me.ComboBoxName...
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
Depends on the view. The new "Report" view in 2007 can be requeried. Preview is static.
thanks pbaldy for sticking with me. i got it working how i want it .
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.
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.