I have records that include # as part of their text string. How can I query for those records and return results containing #?.
FacilityTable
Facility Unit #141A
Facility Unit #241A
Facility #2F
If I search for "unit #" on the search form control
I want the query to return 2 of the three facilityName records in the facility table
Facility Unit #141A
Facility Unit #241A
Query criteria for facilityName:
Like "*" & [Forms]![frmMain]![Navigationsubform].Form!DS!SubFormControlName & "*"
FacilityTable
Facility Unit #141A
Facility Unit #241A
Facility #2F
If I search for "unit #" on the search form control
I want the query to return 2 of the three facilityName records in the facility table
Facility Unit #141A
Facility Unit #241A
Query criteria for facilityName:
Like "*" & [Forms]![frmMain]![Navigationsubform].Form!DS!SubFormControlName & "*"