User Created Sql Queries

Hi Folks,

I am trying to make it that a user can just click on my form and generate a custom sql query.


for example:
If I had three list boxes,I would like my user to be able to click on any of the items in the three boxes and come up with a datagrid displaying the query results.(in effect creating an individual query

i.e
ListBox1
robert redford
dustin hoffman
steve mc queen
ListBox2
butch Cassidy and the Sundance Kid
the Sting
straw dogs
pappilon
List 3
1965
1966(through to)
2008)

So then I want my user to come along click on Dustin Hoffman then click on a film(the sting perhaps) then the year,to find out if Dustin was actually in that film in that particular year...and if he was produce the details.
This will create a "custom" sql statement like

select * from lst 1 ...ect.

What I would like to know is can this actually be done.

This is only a small example of the datbase.I have thousands of films and name ect so it can get quite big.

any help fully appreciated
Gracie