How can I allow my user to search for any information?

I have a table which contains a wide range on information. My user does not want to produce queries only use ones that I make, and preferably wants a filter system from drop down boxes (about 20) without using the menu funtion.

How can i allow the user to extract information without making endless amounts of parameter queries. I also do not have a great knowledge of Access Project.

I'd be grateful of any help, thanks

Your best option is to program a front-end for your database.
A front-end would be something the client uses to interact with the database.
You *never* want the user to issue SQL commands directly to the database!

What type of database are you using?
I know Oracle comes with a form builder that you can use to quickly whip up a simple application.

All of my tables are set up and i have forms and reports running off them. I also have a main menu with basic navigation command buttons. All a want to do now is allow the user to filter ANY information they want from the table. I dont think making endless amounts of queries and linking them on my form is a step in the right direction and want the user to be able to filter by selection without using the menu options.

Im using MS Access 2002 i have copies this SQL stript from a MS access example:

Private Sub Set_Filter_Click()
Dim strSQL As String, intCounter As Integer
'Build SQL String
For intCounter = 1 To 20
If Me("Filter" & intCounter) <> "" Then
strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " & " = " & Chr(34) & Me("Filter" & intCounter) & Chr(34) & " And "
End If
Next
If strSQL <> "" Then
'Strip Last " And "
strSQL = Left(strSQL, (Len(strSQL) - 5))
'Set the Filter property
Reports![rpt Lineside Reports].Filter = strSQL
Reports![rpt Lineside Reports].FilterOn = True
End If
End Sub

The above script shows a pop up filter form in front of a report which is perfect for my needs however this script only seems to respond to one on my combo boxes. It has'nt got the other 19 combo boxes contained in the script. I have little knowledge of SQL and i have just copied this script and followed the instructions on the web page. I know im asking a lot but if there are any miracle workers out there Id be grateful of your help!!