Cannot add without committing row first

[Accessible92866]

I've written a db in Access 2007 to track enrollment in our safety training classes. I have a main form for the basic class information (date, instructor, location, etc.) and a subform for students enrolled in that class, connected by the ClassID field (an autonumber in the Classes table, a long integer in the Attendance table).

When I want to add a new class using the form and attempt to enter the date of the class, it won't generate a new autonumber and won't allow me to do it, giving the message "The value cannot be added to this new row until the row has been committed. Commit the row first, and then try adding the value."

It doesn't seem like it should be difficult just to add a new class. Can anyone help? It's been driving me crazy for days.

Thanks in advance,
Accessible in California

 

[ajetrumpet]

please don't double post: http://www.access-programmers.co.uk/forums/showthread.php?t=172830

 

[missinglinq]

This error usually pops up when you try to enter a (child) record in the subform before there is a corresponding (parent) record on the main form. Is that the situation here?

 

[Accessible92866]

No, I'm trying to add a new class in the main form.

 

[jamilian]

Any resolution to this problem as I have the same one?