B
B. Meincke
I have a form that facilitates teachers entering attendance into our
database. The form sorts on teacher name, then student last name and then
course. Sounds simple enough...except for our co-op teachers. They teach both
co-op and non-co-op classes and the trouble comes from attendance records
needing to be entered in a differnt way and the form not differneciating.
I can filter co-op classes on the underlying query that populates the form.
I can filter non-co-ops likewise. I have saved both filters as queries. It's
easy enough to apply the filters to the query, but only one at a time.
Is there any way I can create a pair of command buttons that would be
visible on the form only when it was a co-op teacher entering records into it
that would allow them to apply each of the filters in turn? That way, they
could enter first co-op student attendance, for example, and then alternate
the filters and enter non-co-op students' attendance.
Or, in my convoluted thinking, overlooking a simpler solution?
Thank you in advance for any assistance offered.
database. The form sorts on teacher name, then student last name and then
course. Sounds simple enough...except for our co-op teachers. They teach both
co-op and non-co-op classes and the trouble comes from attendance records
needing to be entered in a differnt way and the form not differneciating.
I can filter co-op classes on the underlying query that populates the form.
I can filter non-co-ops likewise. I have saved both filters as queries. It's
easy enough to apply the filters to the query, but only one at a time.
Is there any way I can create a pair of command buttons that would be
visible on the form only when it was a co-op teacher entering records into it
that would allow them to apply each of the filters in turn? That way, they
could enter first co-op student attendance, for example, and then alternate
the filters and enter non-co-op students' attendance.
Or, in my convoluted thinking, overlooking a simpler solution?
Thank you in advance for any assistance offered.