Form updated by query wildcard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a from that is being supplied data from a query. On the from I have a
text box for my criteria and a command button that reruns the query and
updates the form. Simple enough, I type smith I get all smith records.
However if I want all records I get nothing. I have tried *, like "*" , 'Like
"*"', with various combos and even leaving it blank but still return
nothing. Not sure what I am missing but I am guessing it's something simple.

Criteria in the query is [Forms]![From Name]![Text Box Name]
command button is Me.Requery

Much Thanks in advance.
 
Try this --
Like [Forms]![From Name]![Text Box Name] & "*"
If you do not select any this you will get all.
 
Worked like a charm. Thanks ever so much

KARL DEWEY said:
Try this --
Like [Forms]![From Name]![Text Box Name] & "*"
If you do not select any this you will get all.

--
KARL DEWEY
Build a little - Test a little


Dan said:
I have a from that is being supplied data from a query. On the from I have a
text box for my criteria and a command button that reruns the query and
updates the form. Simple enough, I type smith I get all smith records.
However if I want all records I get nothing. I have tried *, like "*" , 'Like
"*"', with various combos and even leaving it blank but still return
nothing. Not sure what I am missing but I am guessing it's something simple.

Criteria in the query is [Forms]![From Name]![Text Box Name]
command button is Me.Requery

Much Thanks in advance.
Click to expand...
Click to expand...
 
Back
Top