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 your help
 
I assume you will have a command button on your form that will execute the
query once the field are filled in. In the Click event of the button, you
will have to construct your query as an SQL string that will include only the
fields you want, or create where conditions for those fields, depending on
what you want. If you can post back what you want to happen, I think we can
help. For example, when you enter a value in a control, do you want the
field that control represents included in the query, or do you want all
fields in the table included in the query, and the value in the control or
controls to be used for filtering?
 
Back
Top