Multiple field search box using a drop down box for field and text box for criteria

[Jlb1108]

This is my first access database and I need assistance building a search box that allows the user to choose which field to perform his or her search on. The multiple field combo box returns to many like results to be functional because most of my date is similarly structured( part #s, PO#s, serial #s, item #s, etc). So I need a list box the refers to fields and a text or combo box that contains the search criteria. I feel like this should be easy but I have yet to find video or forum that uses this approach. All help is appreciated

[June7]

I do something like this. User selects field in combobox. Then VBA code changes the RowSource of second combobox to only show DISTINCT values from the selected field. Something like:

    Me.cbxFor.RowSource = "SELECT DISTINCT " & Me.cbxField & _
                    " FROM Projects INNER JOIN Submit ON Projects.ProjRecID = Submit.ProjRecID" & _
                    " WHERE Not " & Me.cbxField & " Is Null " & _
                    " ORDER BY " & Me.cbxField & ";"

Now applying the selection of the second combobox as filter criteria gets rather complicated if the fields are different data types. Fortunately, not dealing with number data types on this particular form.

I have comboboxes for text type fields and values then textboxes for input of date range. VBA code conditionally builds the criteria string. Review http://allenbrowne.com/ser-62.html

Advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention. If you do, code will have to be modified so all object names will be enclosed in [ ] characters in the compiled SQL string.

[Jlb1108]

Thank you. I'll give that a try today.