Multiple Criteria in a string

[cksm4]

Hello,

I am a little new to Access so this may sound basic; In addition to filtering two fields in a form, I need to filter one of the fields based on two criteria. Here is the code I have:

Dim JobTitle As String
Dim strEmploymentStatus As String
strJobTitle = "Employee"
strEmploymentStatus = "Current"
Me.Filter = "[JobTitle] = '" & strJobTitle & "' AND [EmploymentStatus] = '" & strStatus & "'"
Me.FilterOn = True

This works but I also need include matching records for "Contractor" in the strJobTitle. Is this possible? I very much appreciate any help... I'm stuck!

[pbaldy]

Is this what you mean?

Me.Filter = "([JobTitle] = '" & strJobTitle & "' OR [JobTitle] = 'Contractor') AND [EmploymentStatus] = '" & strStatus & "'"

[cksm4]

So simple! It worked... Thanks!

[pbaldy]

Happy to help, and welcome to the site by the way!