I have a search form that I've created, but I've discovered a slight problem. My search form has combo boxes that lists all the different records for every field within a table. One of the combo boxes has facility names and that's where I'm having troubles. There is probably around 200 facilities in this field. Some of these facility names have '#' signs in them, such as MTS #3. Now I just discovered that queries will not accept # sign within it's criteria expression. My SQL statement for the search is like this:
SELECT * FROM MTR_Table Where Facility LIKE '*MTS #3*'
Is there a way to modify my code to accomodate the # sign? Any suggestions? Thanks.