Applying filter to continuous form with or conditions

latex88

Registered User.
Local time
Today, 06:50
Joined
Jul 10, 2003
Messages
198
How to apply multiple filters upon opening a form? I can set filter to one condition with the below code in the OnOpen event, but I actually need to apply the following conditions: [Status]="Open" and [OrderType] ="condition1" or "condition2"

Me.Filter = "[Status] = 'Open' "
Me.FilterOn = True
 
"[Status]='Open' and ([OrderType] = 'condition1' or [OrderType] ='condition2')"
 
Thank you, Paul. That worked beautifully.
 

Users who are viewing this thread

Back
Top Bottom