What I want to do is select a criteria from a drop down box and then use that selection as my criteria in which to search by in my query (that is located in my Microsoft Database).

e.g. Football Teams

In my combo box I have a list of football teams

Manchester United
Tottenham Hotspurs
Arsenal
Liverpool

I now want to select from my visal basic application 'Manchester United'.

Now I Have selected Manchester United my query has now filtered the records so that only those that have Manchester United will be available.

Cheers

Yoda

PS. May The Force Be With you