o1110010
Registered User.
- Local time
- Today, 00:19
- Joined
- Mar 6, 2004
- Messages
- 182
Hello friends and strangers!
I am guessing this problem I have has been resolved already but the closest sounding post so far is this which still leaves me wondering.
In a form I have four unbound text boxes. Each of these textboxes I was hoping could be used to narrow a search if data is entered. If no data is entered, it shouldn't use the textbox to filter in the query. Under these textboxes is a subform that is the query. On the form is also a command button to Me.Refresh to start all the happy filtering fun. I have had no luck at getting it to work how I want. I have had luck to either filter for everything (which takes out too many records) or filter it out seperately (Which leaves too many records).
Example, pretend the four unbound boxes help filter these four fields in a table: numID, txtFirstName, txtLastName, dteDate
if I enter numID, it should only show 1 record since it is linked to the index numbers.
if I enter just "Frank" for txtFirstName, it should show the records of "Frank Johnson", "Frank Smith", and "Frank Peterson".
if I enter "Frank" for txtFirstName and "Smith" for txtLastName, it should only show "Frank Smith".
Any help please?
I am guessing this problem I have has been resolved already but the closest sounding post so far is this which still leaves me wondering.
In a form I have four unbound text boxes. Each of these textboxes I was hoping could be used to narrow a search if data is entered. If no data is entered, it shouldn't use the textbox to filter in the query. Under these textboxes is a subform that is the query. On the form is also a command button to Me.Refresh to start all the happy filtering fun. I have had no luck at getting it to work how I want. I have had luck to either filter for everything (which takes out too many records) or filter it out seperately (Which leaves too many records).
Example, pretend the four unbound boxes help filter these four fields in a table: numID, txtFirstName, txtLastName, dteDate
if I enter numID, it should only show 1 record since it is linked to the index numbers.
if I enter just "Frank" for txtFirstName, it should show the records of "Frank Johnson", "Frank Smith", and "Frank Peterson".
if I enter "Frank" for txtFirstName and "Smith" for txtLastName, it should only show "Frank Smith".
Any help please?