Form to Macro

[Bishoy George]

Hi,
I have a drop down list that on change runs a macro...

That macro runs a query to display table data.

I want to make a selective display of data depending on that drop down list.

--- In Other Words ---
I need when I select something from the drop down list ---> I have a result
depending on the selection.

OR: how to make a query that is waiting for parameter as stored procedures
in MSSQL
and how to send that parameter from a form?

 

[Steve Schapel]

Bishoy George,

You are referring to a Combobox.

In the Criteria of the Query, enter a reference to the Combobox, using
syntax such as...
[Forms]![NameOfForm]![NameOfCombobox]