I am attempting to build a screening database that will ultimately house screening data from approximately 30 different affiliates.
The basic premise is that for a screening event, there are 1 to "infinity" participants. I want to use a form to enter participant data, but I only want to enter the event data one time. So I have created a form that allows me to enter data about the event (name, date, location, host). On this form I have a datasheet subform for participant data. Is there a way to create buttons that say "Open Event" and "Close Event" where any data entered in the subform between those two button presses is automatically tied to the main form event data?
I have attached a screen shot with what I've got, and as solid as my logic is in my head, I'm not super familiar with Access and I'm learning as I go, so feel free to include any and all pointers.