I have multiple text boxes with results for only items with data entered

  • Thread starter Thread starter marnita Florence via AccessMonster.com
  • Start date Start date
M

marnita Florence via AccessMonster.com

Hi Guys,

I have a problem. I have a basic form with 10 text boxes to enter data to
run a query. My problem is how do I get the query to ignore the fields that
are blank without bring back all data int he table

thanks for you help
 
In the query use --
Like [Forms]![YourForm]![YourTextBox] & "*"

Better might be Combox to select - less chance of operator error.
 
Back
Top