Form coding question.

[AlbertaRose]

My form has the following fields.

Contract Number (combo box)
Product Class From (combo box)
Product Class To (combo box)
Description (text box)
Diameter lowest (text box)
Diameter highest (text box)
Beginning Date Range (text box)
End Date Range (text box)
Customer (combo box)
Owner (combo box)
City/Location (combo box)
Province (combo box)
Country (combo box)

Any combination can be requested, some are combo boxes, others are text
boxes. For the Description box, I have made a wild card query to pull
information by specifics, e.g. spheres.

I want to write a query that will look at each of the fields in this form
and determine if there is a value indicated. If so, check the other boxes to
see if there are more parameters and include them in the search. I think I
need an If statement, but have not had much experience yet in this.

Thanks for your patience with a newby...Laurie

 

[Jeanette Cunningham]

Hi AlbertaRose,
there is an excellent sample database for searching on multiple fields here
http://allenbrowne.com/ser-62.html

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia