Using OR in strLinkCriteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am missing something, probably simple. Can someone help with this?

Thanks in advance


stLinkCriteria = "[Unit1EventNumber]='" & Me.EventNumber & "'"_ Or
"[Unit2EventNumber]='" & Me.EventNumber & "'" Or "[Unit3EventNumber]='" &_
Me.EventNumber & "'" Or "[Unit4EventNumber]='" & Me.EventNumber & "'"
 
Paul B. wrote in message
I am missing something, probably simple. Can someone help with this?

Thanks in advance


stLinkCriteria = "[Unit1EventNumber]='" & Me.EventNumber & "'"_ Or
"[Unit2EventNumber]='" & Me.EventNumber & "'" Or "[Unit3EventNumber]='" &_
Me.EventNumber & "'" Or "[Unit4EventNumber]='" & Me.EventNumber & "'"
Click to expand...

You will need to include the "ors" in the string/statement, perhaps
something like this

stLinkCriteria = "[Unit1EventNumber]='" & Me.EventNumber & _
"' Or [Unit2EventNumber]='" & Me.EventNumber & _
"' Or [Unit3EventNumber]='" & Me.EventNumber & _
"' Or [Unit4EventNumber]='" & Me.EventNumber & "'"
 
Excellent, Thanks Roy. I knew it had to be the quotes, I am still having a
heck of a time getting all the variations down pat.

Cheers


RoyVidar said:
Paul B. wrote in message
I am missing something, probably simple. Can someone help with this?

Thanks in advance


stLinkCriteria = "[Unit1EventNumber]='" & Me.EventNumber & "'"_ Or
"[Unit2EventNumber]='" & Me.EventNumber & "'" Or "[Unit3EventNumber]='" &_
Me.EventNumber & "'" Or "[Unit4EventNumber]='" & Me.EventNumber & "'"
Click to expand...

You will need to include the "ors" in the string/statement, perhaps
something like this

stLinkCriteria = "[Unit1EventNumber]='" & Me.EventNumber & _
"' Or [Unit2EventNumber]='" & Me.EventNumber & _
"' Or [Unit3EventNumber]='" & Me.EventNumber & _
"' Or [Unit4EventNumber]='" & Me.EventNumber & "'"
Click to expand...
 
Back
Top