I have a subform that is set to AllowAdditions = True. It is a single record subform with Navigation Buttons on the Parent that I created (not MS Access Nav Bar). I did this because the form has an unusualy user interface. It was confusing the for the user to keep hitting the [Next] Button and wind up on a new record. With defaults displaying, it was not clear whether it was a new record. So in the code for the [Next] Button I set the AllowAdditions = False before I do the GoTo. This prevents the user from going to a new record. GREAT!
However, I would like to reset AllowAdditions = True after the Goto. But Access doesn't seem to execute the code. I now set the AllowAdditions = True on the CurrentEvent on the Parent Form and this resolves the problem. I needed to do this so the subform displays when I go to a new Parent Record.
But I'm Curious. Has anyone else seen this? Does anyone have a more eloquent solution. Like in the code of the [Next] Button?
Thanks for your help!
However, I would like to reset AllowAdditions = True after the Goto. But Access doesn't seem to execute the code. I now set the AllowAdditions = True on the CurrentEvent on the Parent Form and this resolves the problem. I needed to do this so the subform displays when I go to a new Parent Record.
But I'm Curious. Has anyone else seen this? Does anyone have a more eloquent solution. Like in the code of the [Next] Button?
Thanks for your help!
