Hello,
I am trying to figure out the code and am having some trouble. I have a form with a drop down parameter list that opens up a report. The code I am using is
Private Sub openFacType_Click()
DoCmd.OpenReport "Noise Report", acViewReport, , "[Facility Type]='" & cboFacType & "'"
End Sub
This is working great but I have another field with a "2nd facility type" because some of the facilities are more than one type.
I need to know how to make this code grab the records from both of the fields and not just the "Facility Type" field.
I am sorry if this sounds confusing but any bit of advice would be greatly appreciated.
Thanks! Lauren