I have a form with two subforms and they all use the same tables.
On one subform I always allow additions and they are many to many records.
On the second subform I only want to allow for one to many records. Based on what option they choose when I open the form I hide/show the appropriate form. On the second subform if they open it with existing records I set Me.AllowAdditions = False because the initial record already exists and I don't want them to add a second record. If they open the form to add new records, It opens with Me.AllowAdditions = True and after they add the first record I set Me.AllowAdditions = False so they can't add a second record. It all seems to work as I intended but my problem is if they use the form control of arrows to move through the records it will move past the last record and add a new record but because Me.AllowAdditions = False the subform has no fields to enter the data because it's still on Me.AllowAdditions = False and didn't detect that it's a new record.
Is there a way to detect that it's a new record and change Me.AllowAdditions = True?