How can I use a wildcard * in setting the criteria?
To be more specific, I have a field called ItemCode which
contains for example, 001A. But I would like to match
only the 001, without the the character 'A' , to a variable.
So, I thought I would write this way:
rs.FindFirst " ItemCode = ' " & txtItemCode & " * ' "
But it wouldn't work. Can anyone please help?
Thank you very much.