Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No Current Record on a continous form subform

Status
Not open for further replies.

MissionCreep

Programmer
Dec 8, 2017
8
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top