S
Sarah at DaVita
I have a form that is linked to a sub form. These are connected via a class
name so when they user filters the main form to a specific class the sub form
returns only the students in that class. The data returned contains email
addresses. I would like to have the ability to send an email to everyone in
the specified class so I don't have to type each name in order to update the
students on scheduling or locations.
I can currently send an email to every student in the data base using the
following code in a function: strSQL = "SELECT tblEmailList.Email FROM
tblEmailList WHERE (((tblEmailList.Email) Is Not Null))ORDER BY
tblEmailList.LE,tblEmailList.Email;" What I can't seem to do is limit this
to just the specific students in a class based on what the user filters to in
the main form. Can someone help me?
name so when they user filters the main form to a specific class the sub form
returns only the students in that class. The data returned contains email
addresses. I would like to have the ability to send an email to everyone in
the specified class so I don't have to type each name in order to update the
students on scheduling or locations.
I can currently send an email to every student in the data base using the
following code in a function: strSQL = "SELECT tblEmailList.Email FROM
tblEmailList WHERE (((tblEmailList.Email) Is Not Null))ORDER BY
tblEmailList.LE,tblEmailList.Email;" What I can't seem to do is limit this
to just the specific students in a class based on what the user filters to in
the main form. Can someone help me?