Hi all,
So my serch function works fine however i would like to add a wildcard (*) Its to do with reference numbers which begin with letters followed by a dash then numbers (AB-123) (qw-321)
So i would like to search without the letters but including the dash
rs.FindFirst "[FaultNumber]=""" & Text19 & """"
This is what im using, where would i put the wildcard? i have tried a few different combos but no joy yet.
A little help please?