Hey all -
I posted here a few days ago looking for help, and now I have a new issue... This is a database to track teacher information and participation in an environmental education program. Everything seemed to be going great until I noticed something funky with my form and the records it displays.
The main table (tblTeacherInfo) is for teacher information, the other table (tblProgramsAttended) tracks program attendance and it pulls from a third table (tblProgramInfo) that lists the types of programs. I have posted a screenshot of the relationships window, as well as two screenshots to show that records 4 & 5 in form view are duplicate. Now, the tables do not have duplicate records - it just shows it in the form. (Note: I "redacted" some personal info from the screenshots.)
The form lists teacher info and has a subform which shows the program attendance. The duplicate form record only occurs if I enter more than one record in the subform. If I delete one of the duplicate records, it also deletes the second record in the subform. If I add a second record to the subform, the duplicate does not appear until I close and reopen the database. Any ideas what I need to do to fix this issue? Happy to provide more information - just please keep in mind I am a novice, so define those acronyms and database jargon.
I have an earlier version of this database (a control, if you will) where I was not having the duplication issue. I have gone back through the older version and redone any changes I can think of or see, but can't get the issue to occur in my control, or fixed in the latest version.
I was experiencing a strange error earlier whenever I clicked into the subform that said "The expression On Enter you entered as the event property setting produced the following error: Object or class does not support the set of events." - I resolved this by deleting the [Event Procedure] that had somehow appeared in the "On Enter" field of the Properties window for the subform. Somehow I feel that this error and my duplication issue are related (it's too coincidental), but I've been wrong before.
Thanks,
Joe