Access 2010 - Main Menu Needs a Drop Down Box Referencing a table for a SEARCH

[Parker]

Hello All,


I have a main menu "MainMenuF" in my database and I would like the database to be able to be searched by any of the column headings. For example I have a table titled "NewLabReportT" this table has many column headings like "Submitted By" "Reviewed By" "Title" "Abstract" etc...


I would like my users to be able to click a radio button with the same column headers on this main menu and have a box that pops up to say "Enter search parameter" and have that parameter be searched in the table "NewLabReportT" and generate a FORM not a REPORT of all of the listings in the database that have that keyword associated to that certain category searched. That way they can "CLICK" the exact field they are looking for and have it open right up to that form.


Thank you all for your help!

[June7]

Will need code, I use only VBA.

I use a combobox that lists the table fieldnames. Another combobox to list values that are in selected field. This synchronization is managed by VBA code. More code constructs filter criteria.

If you want to allow multiple criteria, that gets more complicated. One approach is dynamic parameterized query (I never use).

[ranman256]

you could have 2 list boxes,
List1 has all the fields available.
User dbl-clicks a field in List 1, which is a param to be set, and sent to List 2.
List 2 shows the fields and a 2nd column to enter the value.

Build the sql off the List2.