**
**
i have a form "frmCustomerSurveySheet" that has a command button "open report"code above. This button opens my report (Report1) with the selected record. works fine...BUT...i have another form (thanks to jimmythegeek)<qryCustName> ,on this form i have 4 combo boxes that are used to search/select customer info. I have a button on this form that, once you have selected your customer info, opens the "frmCustomerSurveySheet". Here's the problem...when the form opens<frmCustomerSurveySheet> with the selected record <from qryCustName>i can't use the "open report button"...it gives me, the "apply a filter first" msg box....so......how do i make that button open the report with the record i selected from my customer info search form <qryCustName>??? [sig][/sig]
Code:
Private Sub cmdOpenReport_Click()
If Me.Filter = "" Then
MsgBox "Apply A Filter to the Form First!!"
Else
DoCmd.OpenReport "Report1", acViewPreview, , Me.Filter
End If
End Subi have a form "frmCustomerSurveySheet" that has a command button "open report"code above. This button opens my report (Report1) with the selected record. works fine...BUT...i have another form (thanks to jimmythegeek)<qryCustName> ,on this form i have 4 combo boxes that are used to search/select customer info. I have a button on this form that, once you have selected your customer info, opens the "frmCustomerSurveySheet". Here's the problem...when the form opens<frmCustomerSurveySheet> with the selected record <from qryCustName>i can't use the "open report button"...it gives me, the "apply a filter first" msg box....so......how do i make that button open the report with the record i selected from my customer info search form <qryCustName>??? [sig][/sig]
