Creating a Parameter Query that works in SQL

[Leaner79]

Hi,
I have this problem. I have created a function query in my SQL database. However i want to filter the data that i see.

For example, i want to have a form where i input a value that should be used for filtering. Or i can have a dialog box come up and in the dialog box i can have a combo box where i select a value and it filters using that.

I did this once before in access and the value i put under "critea" on the query was =[Forms]![Formname]![Textbox]
this gave me only results that had the same value as the one in my textbox..

Please help

 

[AlexCuse]

What you are asking seems to be more of a gui question. Can you post teh query that you have ATM?

Ignorance of certain subjects is a great part of wisdom