Passing OPENARGS to query

[david]

I have a form based on a query.
When the form is opened an ID is passed in Openargs.
The recordsource of the form is this query:

SELECT *
FROM Comment
WHERE AssignmentID = [openargs];

But I am being promppted for openargs, why is it not being
recognized?

 

[chris]

Try...

SELECT *
FROM Comment
WHERE AssignmentID = " & cstr(Me.openargs) & ";"

 

[Van T. Dinh]

Try using the Query WITHOUT criteria and use the "wherecondition" argument
of your OpenForm command instead.