Where to edit for partial match

August 23, 2017 at 07:43:05
Specs: Windows 7
I have a VBA code that someone made for me, it currently takes the user input and searches the field for an exact match then returns the record. I would like to be able to enter partial data and return all records that match. I am not sure where or how to make the edit. I believe it is in this portion of the code:

If Not IsNull(Me.SALES_ORDER) Then
strWhere = strWhere & "([SALES_ORDER] = """ & Me.SALES_ORDER & """) AND "
End If

This is in an Access database.

See More: Where to edit for partial match

Report •
Related Solutions

Ask Question