I have a form with a list of schools however I want to filter any schools that have bookings for next year away from this list.
I thought of using recordset by making an sql string, list all the bookings with criteria and then produce a list of schools that have those bookings.
from that list I would then collect the IDs and use that to...
filter any of the schools that match those IDs out of the list.
Then after it is filtered I would go through that recordset and email each record. Since the schools that had bookings have been filtered out - they wouldn't be emailed.
Is this possible, what functions/rules would have I have to learn and use?