Passing OPENARGS to query

D

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?
 
V

Van T. Dinh

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