Senniger1
asked on
Access 2010 Where Condition on a DoCmd OpenForm
I need to combined these together and separated with OR for a WHERE CONDITION on a DoCmd OpenForm.
'2
stLinkCriteria2 = "[RoutedTo] like '???/" & txtCategoryList & "*'"
stLinkCriteria2a = stLinkCriteria2 & " And [AllItemCal2] is Null"
'3
stLinkCriteria3 = "[RoutedTo] like '???/???/" & txtCategoryList & "*'"
stLinkCriteria3a = stLinkCriteria3 & " And [AllItemCal3] is Null"
'4
stLinkCriteria4 = "[RoutedTo] like '???/???/???/" & txtCategoryList & "*'"
stLinkCriteria4a = stLinkCriteria4 & " And [AllItemCal4] is Null"
In other words, I should end up with something like...
stLinkCriteria = stLinkCriteria2a OR stLinkCriteria3a OR stLinkCriteria4a
Can someone help me with the syntax.
Thanks in advance!
'2
stLinkCriteria2 = "[RoutedTo] like '???/" & txtCategoryList & "*'"
stLinkCriteria2a = stLinkCriteria2 & " And [AllItemCal2] is Null"
'3
stLinkCriteria3 = "[RoutedTo] like '???/???/" & txtCategoryList & "*'"
stLinkCriteria3a = stLinkCriteria3 & " And [AllItemCal3] is Null"
'4
stLinkCriteria4 = "[RoutedTo] like '???/???/???/" & txtCategoryList & "*'"
stLinkCriteria4a = stLinkCriteria4 & " And [AllItemCal4] is Null"
In other words, I should end up with something like...
stLinkCriteria = stLinkCriteria2a OR stLinkCriteria3a OR stLinkCriteria4a
Can someone help me with the syntax.
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
pls try
stLinkCriteria = stLinkCriteria2a & " OR " & stLinkCriteria3a & " OR " & stLinkCriteria4a
stLinkCriteria = stLinkCriteria2a & " OR " & stLinkCriteria3a & " OR " & stLinkCriteria4a
ASKER
Perfect!
Yes, like Rgonzo says.
ASKER
Shouldn't the following line be formatted some way as well?
stLinkCriteria = stLinkCriteria2a OR stLinkCriteria3a OR stLinkCriteria4a
Thanks!