FindNext Problem

[Mark Jones]

I have a table that contains a field called PurchaseOrderNumber. In this field the data is type String, and looks like this;

NM001-018
NM001-018-001
NM001-018-002
NM001-018-003
NM001-019
NM001-019-001 etc...

I need to set up a criteria string for FindNext which will match a sub-string match like "NM001-018" so that it will match all of the NM001-018xxxx strings. I know this can be done in a query but I need the match to be delivered back to VB code. Maybe FindNext is not the right method, but I can't seem to find a method which will work short of MoveNext / extracting the field / and then using the Mid function to see if the sub-string matches. Very inefficient over lots of records.

Thanks for any ideas in advance!


Mark

 

[Mark Jones]

I didn't know you could do this!

Thanks!

Mark Jones