Multiple Find Record Fields on Form

[hullstorage]

I am trying to create a form to search records from a table

the text boxes and combos will be:

By Specific Date
By Date Range
By Customer
By Order No
By Invoice No
By Month

Any ideas on the simplist way of tackling this as i dont want to really create millions of queries if possible

Many Thanks

Simon

 

[boblarson]

I am trying to create a form to search records from a table

the text boxes and combos will be:

By Specific Date
By Date Range
By Customer
By Order No
By Invoice No
By Month

Any ideas on the simplist way of tackling this as i dont want to really create millions of queries if possible

Many Thanks

Simon

Perhaps this sample will get you pointed in the right direction:
http://downloads.btabdevelopment.com/Samples/combos/FormSampleFromMultipleCriteria.zip