Search Forms

[Guest]

I am struggling terribly with using a search form to pull from my
tables/queries. So far I have encountered several issues that I need help
with.

First, how can you select particular fields to search with using a drop down
box, but be able to gain results while leaving a couple fields blank?

Second, how can you search tables/queries by using a checkmark method that
you can pick and choose what fields you want to include? This stage has
effected some of my positive discoveries with a drop-box feature.

Thanks...this should be all for now.

 

[Allen Browne]

Travis, have you done anything with VBA code?
If so, this example may help:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

It includes a downloadable example that illustrates how to combine criteria
for Text fields, Number fields, and Date fields, using text boxes, combos,
and a range of values.