How to filter a recordset using a combo (ASP)

[ESIP]

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]

[bregent]

I don't quite understand where you are having problems.You have a form with a combo box that submits to a script that runs the query and returns the recordset, right? Where exactly are you having difficulties?

[ESIP]

Hi,

Thanks for your reply.

I don't really know how to do it.

Please explain me how to do it.

Thanks,

Marco