MissionCreep
Programmer
I have a subform where I want users to enter notes regarding the current record on the parent form. The subform is a continuous form. In the header of the subform I have a button to add a new note. The click event of the button sets AllowAdditions = True, performs AddNew on the subform's recordset, populates some fields, performs Update, and then sets AllowAdditions = False.
This works fine unless you view this subform for a record that has a note, and then move the parent form to a record that has no note. Then when the user clicks the button he gets a No Current Record error. Once you click on the error it works fine. It's just damned irritating and I've spent about a day trying to come up with different schemes to stop the error.
This works fine unless you view this subform for a record that has a note, and then move the parent form to a record that has no note. Then when the user clicks the button he gets a No Current Record error. Once you click on the error it works fine. It's just damned irritating and I've spent about a day trying to come up with different schemes to stop the error.