How to filter a recordset using a combo (ASP)

Hi.

I have my website in ASP linked to an Access database using DSN. It is working ok.

I need some help to make a filter in a recordset, but the filter is a combo box that any time that a value is choosed the data int he grid/table is also changed.

Here it is my code:

SELECT *
FROM qry_YTD
WHERE DirMan = MMColParam
ORDER BY id_fy DESC, tot desc

Please somebody help me.

Regards,

Marco

[Moved by moderator to the appropriate forum]