stLinkCriteria and OR

[hockeyfan21]

Hi,

I'm having trouble with the below code - When I initially open the database and select an item in cboASR, I get this error message:
Syntax error (missing operator) in query expression 'ASR User Id] = 'thart' OR'

If I then select something in cboCust as well, it works fine, then I can go back and select an item in cboASR.
What can I do to avoid the error on the initial selection?

If Not IsNull(Me.cboASR) Then
stLinkCriteria = "[ASR User Id]= '" & Me.cboASR & "' OR"
End If
If Not IsNull(Me.cboCust) Then
stLinkCriteria = stLinkCriteria & "[Sold To Name]='" & Me.cboCust & "' "
End If

DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks in advance for any help with this!
Toni

 

[pbaldy]

If the user will always choose the first, move the OR to the second, like:

stLinkCriteria = stLinkCriteria & " OR [Sold To Name]='" & Me.cboCust & "' "

 

[GinaWhipp]

What is the *OR* for? What happens if you change it to...

If Not IsNull(Me.cboASR) Then
   stLinkCriteria = "[ASR User Id]= '" & Me.cboASR & "'"
End If

 

[pbaldy]

What is the *OR* for?

Gina, "AND" and "OR" can be used...

 

[GinaWhipp]

@pbaldy

Yes, I know that but wondering why it ia there as it will produce an error if nothing is on the other side (well at least the way the OP has done it. Your way will not because it is not at the end of the first line. Okay, I guess I could have been clearer.

 

[hockeyfan21]

Pure genius!!! Thank you so much, that worked perfectly, was driving me crazy!

 

[pbaldy]

Whoever's solution you used was glad to provide it.