Setting query value form form

[Daryl2106]

Hi,

I am trying to access the same query/report from different forms. For example I have a StudentAttendanceForm where users select a StudentID and then open the report. The query criteria for ID# is [Forms]![StudentAttendanceForm]![StudentID].

Can I access this same report from an event on another form. I'm thinking that if I can some how assign the StudentID from the form I want to access the report from, to the criteria on the StudentAttendanceReport Query, this is possible. I am new to code but I am thinking something like:

SET [StudentAttendanceQuery]![StudentID] TO [StudentEnrollmentForm]![StudentID]
Open StudentAttendance Report

The StudentEnrollmentForm is the other form I want to access the report from

You may need a crystal ball for this one. Let me know what other info you need.



In general I am finding I am copying and tweaking queries to meet specific user needs. For eamply some want to access a single student and other need "batch" reports. What is the general way about this/

Thanks and take care,

Daryl

[Dal Jeanis]

One easy way to do this is to change the query to access one or two Tempvars variable(s), and set the same Tempvars in each case before calling the query.

If you want to be able to use the same query to get a single student or all students, then you can either use

WHERE StudentID BETWEEN X AND Y

and for a single student, set Tempvars X and Y both to the student ID, and for all students, set them equal to the low and high student IDs in the database.

Alternately, you could use

WHERE StudentID LIKE X

and for a single student, set Tempvars X to the student ID, and for all students, set it to *.