Apply Filter in two fields

[vorn666]

Hi all,

I have the following working line of code (Running once a button is pressed in a form)

DoCmd.ApplyFilter , "[Site Location] = 'Site A'"

However I now need to modify this to search for the text in two fields, both Site Location and Site Location2, to return results if it is found in either field.

Any help greatly appreciated, as I have tried various ideas and it either returns all records or no records.

Cheers,

 

[Peter Reid]

DoCmd.ApplyFilter , "[Site Location] = 'Site A' OR [Site Location2] = 'Site A'"

 

[johndoomed]

Something like this?

varLocation = "Site A"
Me.filter = "([Site Location] Like " & varLocation & ")" & Or & "([Site Location] Like " & varLocation & ")"
[PHP]

 

[vorn666]

Many thanks Peter - works perfectly!

John, will look into yours too when I have finished this update, as it looks like i will learn a few things going through that one.