Question Text, Number, Combo Box, and Check Box Search

[OnlyAGentleman]

Hi All,

I have one main table with all of the information for a lessons learned database, a company project, and a form that enters the information easily into it.

My main problem is fine tuning the search result. I currently have a form that includes text fields, boxes to enter numbers, a few combo boxes, and a load of check boxes. I then have a query that looks at the parameters of the search and decides what will be shown in a final, results form.

I have figured out the checkbox problem, by I still have the following problems with other sections:

The Text Fields - I cannot limit the search for all of the fields, I have many fields (I will attach a picture), and have been using a Like "*" & [forms][formname][textboxname] & "*" to no avail.

The Combo Boxes - Plain and simple I cannot get these to function either

Number Boxes - i would love to hear a proposition on how to limit the search by numbers that represent things like budget, size of team, and number of hours worked.

Thanks very much in advance!!

 

[billmeye]

Are you using a query and trying to set the column criteria's based on your forms selection? Or, are you trying to modify controls shown on a form based on the forms selection? And, it would be helpful to see your DB to get a better understanding why your using the search form. Thanks.