Referencing query criteria from a from using SQL 2000 and Access 200

[millos21]

Hello,

I have an Access .adp linked to SQL Server 2000. I have a form in Access and I want to create a query where the referencing value comes from the form.

In regular .mdb file I would create a query and in the criteria field I would reference the value from what is in the form like this:
Forms![Form1]![fieldname]

how can I do this in an .adp file. I know I have to write some code passing a pass-through query to a stored procedure, I just don't know how to create this code.

Thanks,