Could someone help me to apply two filter into one please?
I have tried several iterations but to no avail.
Both work independently.
I tried this which doesn't create an error but returns no results
As always your invaluable advice is much appreciated.
I have tried several iterations but to no avail.
Both work independently.
Code:
DoCmd.ApplyFilter , "Status = '...awaiting decision'"
DoCmd.ApplyFilter , "customer = [Forms]![frmSettings]![UserName]"
I tried this which doesn't create an error but returns no results
Code:
DoCmd.ApplyFilter "", "[Status] Like '...awaiting decision' And_
[customer ] Like '[Forms]![frmSettings]![UserName]'"
As always your invaluable advice is much appreciated.