I have two lines, this one works great:
WHERE [ProductCode]='" & Me.cmboNames & "'"
This one does not work:
WHERE [WorkOrderNumber]='" & Me.cmboNames & "'"
The only difference I can see is that [ProductCode] is of dataType Text and [WorkOrderNumber] is of dataType Number
Could this be causing the problem? If so what is the fix?
Thanks.