I have a report based on the following sql:
SELECT products.grade, products.code, products.size, products.Productid
FROM products
ORDER BY products.grade, products.size;
I want to open a report from a form with the Where Condition :
WHERE (((
.)=205))
Also i want to open the report with the following where condition:
WHERE (((
.)=6))
I am afraid the way i have built the code is not right. It is the following:
Dim stDocName As String
stDocName = “rptLists”
DoCmd.OpenReport stDocName, acPreview WHERE (((
.)=205))
Can somebody help me?
