sql in vba to update record WHERE

[ShostyFan]

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.

[ShostyFan]

fixed it, sorry for the premature post.
when you have different data types you must put LIKE instead of = after the WHERE
so:
WHERE [WorkOrderNumber]='" & Me.cmboNames & "'"
was fixed by
WHERE [WorkOrderNumber] LIKE '" & Me.cmboNames & "'"

[Micron]

Not really. When it's text it has to be delimited with single or double quotes (how depends on the situation). If date data type, octothorpes (#) if numeric data type, nothing. That is the correct method for this. LIKE is using pattern matching, which in this case is a kind of hack.