So I have now solved 3 problems with my form filter thanks to everyone's help.....
I believe the very last problem is as follows:
In the form header section is an Unbound Text box called txtStreet (which is a text data type in the table). The VBA code is using an If statement to treat it as such like a text field should be treated.
The problem comes along when I try to input one of the Street names that have a '#' symbol somewhere in it. If I type in the first part of the Street, it will work and find it in the Results section, but if I include the whole Street field, it will not find it, when it should find it.
I am attaching the sample database to ask for help for anyone who would be so kind to help me out with the VBA on this. There is only one person in the Query results with a '#' symbol in their Street field (so this would be the test person).