VBA string with OR expression

[hmcquade]

Hi!

I have a form with a search command button, at present, when clicked it brings up all records for jobs 'In Progress', using the following code:



Private Sub Search_Click()
Search_String = "[Status]= 'In Progress'"
DoCmd.ApplyFilter , Search_String
End Sub

I would like this command to also bring up all jobs 'On Hold' as well as those 'In Progress', but i am having trouble getting the OR expression right.

This may be really simple, but i have tried a few combinations and just cannot do it! Can someone PLEASE help me!

Thanks in advance!

[khalid]

change your code to:

Private Sub Search_Click()
Search_String = "[Status]= 'In Progress' OR [Status] =" & "'On Hold'"
DoCmd.ApplyFilter , Search_String
End Sub

This should solve the problem:

[hmcquade]

thank you very much that worked!!!!

[khalid]

Glad that it solve the problem, just mark the thread as solved (top right of the thread tools) and mark this thread as solved.

Thanks!