Query Selection Criteria

[TheNoocH]

I have a form that has 2 text boxes...Item From and Item To
I have a query that i want to set up to read the two boxes as my search criteria...
I have it working using the following...
Between [forms]![frmInv]![txtItemFr] And [forms]![frmInv]![txtItemTo]
I tried putting in an * into both the from and to in an effort to show all records....but that didn't work....any ideas? my goal is to default the text boxes to show all records...thanks

 

[Joe4]

What kind of field is this? Is it a date field? If so may need txtItemFr and txtItemTo to be formatted as dates, or handled a little differently.

 

[TheNoocH]

It is a text field...it accepts item numbers...
my workaround was to default the from = 0 and the to = zzzzzzzz
it appears to work but i thought there might be an easier way to do it to ensure it's all encompassing

 

[giacomo]

Wildcards only work with the LIKE operator that is why typing "*" did not work for you. Your work-around should work well, except that it will ignore nulls. Post back if you have null values and need to come up with a more all encompassing solution