In a database used for event registrations, I have a form with 2 subforms that are linked by Event ID and Attendee ID. The subforms are for the attendee pay items and event options. This worked perfectly for the first event in which we registered almost 500 attendees.
For the 2nd event, I have made some modifications to the form, but none related to the way I want the forms linked. However, now, when I enter a new record in the main form, the subforms are being populated with another attendee's data as soon as I enter the Event ID - before I have entered the Attendee ID (both of which are selections from combo boxes).
Any ideas on why this is happening?
Thanks so much!
For the 2nd event, I have made some modifications to the form, but none related to the way I want the forms linked. However, now, when I enter a new record in the main form, the subforms are being populated with another attendee's data as soon as I enter the Event ID - before I have entered the Attendee ID (both of which are selections from combo boxes).
Any ideas on why this is happening?
Thanks so much!
