Multiple Criteria on Form to open Report

[monkeysee]

I have a form with 1 combo box and 2 text boxes all are unbound. My combo box is named combo6 and and the text boxes are text2 and text4.
The combo box houses the EmployeeName; and the 2 text boxes gives a choice for a start date and an end date. My report to be opened: EmpBalSheet. The form is: EmpBalSheetFilter. The Query is QryEmpBalSheet with the fields EmployeeName and VisitDate.
My Event procedure (DoCmd.OpenReport "EmpBalSheet", acViewPreview, , "[VisitDate] Between #" & Me.Text2 & "# And #" & Me.Text4 & "#") opens the report and displays the correct date range that has been chosen. But my problem is how to add the EmployeeName combo box to the procedure. Any help will be greatly appreciated. Thank you in advance!

 

[Micron]

If the report opening cannot occur when the combo has no selection (no value in it) and the first column of the combo contains that value, then
"EmployeeName = '" & Me.combo6 & "' And [VisitDate] Between #" & Me.Text2 & "# And #" & Me.Text4 & "#"

 

[monkeysee]

If the report opening cannot occur when the combo has no selection (no value in it) and the first column of the combo contains that value, then
"EmployeeName = '" & Me.combo6 & "' And [VisitDate] Between #" & Me.Text2 & "# And #" & Me.Text4 & "#"

Thank you Micron for your help! It works..

• :wink:
  
  

• 
  
  

 

[Micron]

You're welcome