Running a report with a where condition

[onechriswhite]

Hi,



I need one report run under several conditions. It will show student test results but I will need it to print for a particular class (ClassIDKey) and a particular test (TestIDKey) when called from one form, or all classes when called from another form.

I have added a where clause to the "on click" event of the command button that calls it - I want it to print for a particular class and test that are currently open on another form (FRMStudentTestMarks):

"TestIDKey=" & [Forms]![FRMSTudentTestMarks].[TestIDKey] & " AND ClassIDKey=" & [Forms]![FRMSTudentTestMarks].[ClassIDKey]

I can't get it to work! Should I be using the "Filter" option instead?

Thank you

[ranman256]

If The query in the report has this in its criteria, it will work. IF you always use both filter fields.
if sometimes, only 1 field is used, it will fail. My reports use your method and it works.

Test by picking your items in the fields, validate in Immediate window (ctrl-G) by
?forms!frmStudentTestMark!testID

dont use periods...use exclamations.
test all criteria here to make sure of your values.

[onechriswhite]

Hi, thanks for the reply.
I don't want the condition in the query as I want to use the same query for other reports.
I took away the characters trying to "build" a text SQL query and just wrote it plain with exclamations and it works:
[ClassIDKey]=[Forms]![FRMStudentTestMarks]![ClassIDKey] And [TestIDKey]=[Forms]![FRMStudentTestMarks]![TestIDKey]

What's the difference between . and ! in these cases?

Thanks again, happy it works now!

[June7]

The . invokes intellisense popup tip in VBA.

I use . when I want to reference control names, ! for field. If control has same name as field it is bound to, either character should work.