Error message: Update or CancelUpdate without Addnew or Edit

[ppataki]

Dear All,

I have a really big problem with a form
It contains checkboxes, each is bound to a Yes/No field
After ticking these checkboxes I click on another form that is also open, and when I click back on the previous form, the ticks from the checkboxes are gone!
And if I would like to recheck them I get the above error message

Could you please help me?

Many many thanks in advance

 

[ajetrumpet]

Dear All,

I have a really big problem with a form
It contains checkboxes, each is bound to a Yes/No field
After ticking these checkboxes I click on another form that is also open, and when I click back on the previous form, the ticks from the checkboxes are gone!
And if I would like to recheck them I get the above error message

Could you please help me?

Many many thanks in advance

the error from above is a recordset specific error from VBA. check your coding between the two forms and see what is there. check all the events of both forms, and the events of the tick boxes to see what is running out there.

 

[boblarson]

Both forms aren't bound to the same table or query are they?

 

[ajetrumpet]

true. have had that problem before with a popup form open as data entry above a form with the same name. usually a different error message comes up about another user having the form open though, no?

 

[boblarson]

true. have had that problem before with a popup form open as data entry above a form with the same name. usually a different error message comes up about another user having the form open though, no?

Usually, but hard to say, so I'm throwing various things out so we can hopefully make heads or tails of it.

 

[ppataki]

In the meantime I figured out a solution
The problem was that upon opening the second form a VBA was run to jump to the same record where the first form was (recordsetclone bookmark method was used)
After replacing that code with a DoCmd.OpenForm command, using its Where condition the error is gone!