I"m creating an openform macro where the form will open to specific records containing all or part of the string the user provides
where condition = [Customer Ref #] like Forms![fFindShpt]! *[Combo26] *
Customer Ref # = the field the form is filtered by
combo26 = all or part of the string the user provides.
there is something wrong with my where condition but i don't know what it is.
Can anyone suggest a better where condition expression?
thanks