Passing OPENARGS to query

  • Thread starter Thread starter david
  • Start date Start date
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?
 
Try using the Query WITHOUT criteria and use the "wherecondition" argument
of your OpenForm command instead.
 
Back
Top