perplexed about an "Update... without AddNew..."

[markjkubicki]

There is one (1) field in a combobox on my form where if the user changes the entry once, they'll encounter no problems, but if they go to change its value a second time (that is without having saved the record after the first change by moving to another record and returning), they get this error:



"Update or CancelUpdate without AddNew or Edit"

It is frustrating themto no end; and on this... I am stumped
(This does not happen with any ofthe other (many) fields / controls on the form... just this one


I will take (with MANY thanks in advance) ANY suggestion whatsoever (truely... "anything"...)

mark

[ItsMe]

What is, " one (1) field in a combobox"? I am not following ...

[Micron]

I posted an answer, which seems to have disappeared
Short version:
- probably means a single column
- have read where this can be fixed by a compact/repair
- or there is code running in the wrong event
- or it happens when form is linked to and ODBC source and the record is not saved before re-selecting (the combo may initiate an edit, or code behind it might be doing so).
- if it's OK to save the record upon a new combo selection, do so in the (I think) BeforeUpdate event of the combo via
If Me.Dirty = True Then Me.Dirty = False

[John_G]

Is the combo box bound to a table field?
What is the VBA code you have behind the combo box?