vegemite
Registered User.
- Local time
- Tomorrow, 02:38
- Joined
- Aug 5, 2019
- Messages
- 64
Hey experts! I have a form that I want the user to be able to search for relevant jobs with a number of fields. I want to use unbound text boxes for project name and client then (at this stage while I am testing) get a query to return relevant records.
I've used wildcards in each of two fields with these criteria - Like "*" & [Forms]![MyFormName]![Thenameoftheunboundbox] & "*"
When I run the associated query with nothing in my search boxes I get all records, the minute I enter something in the form... even the letter "a" I get no records?
This was supposed to only be the first stage of this, ideally, I might have some drop-down boxes to help the user refine the records and show a subform then go to the selected record.... I cant even nail this first step!
I've used wildcards in each of two fields with these criteria - Like "*" & [Forms]![MyFormName]![Thenameoftheunboundbox] & "*"
When I run the associated query with nothing in my search boxes I get all records, the minute I enter something in the form... even the letter "a" I get no records?
This was supposed to only be the first stage of this, ideally, I might have some drop-down boxes to help the user refine the records and show a subform then go to the selected record.... I cant even nail this first step!