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
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