Stupid error that I DO NOT KNOW HOW TO FIX

[Ma3x323]

Hi,
Newbie here and I keep getting this error saying "Update or CancelUpdate without AddNew or Edit".

WHAT THE HECK DOES THAT MEAN?!?!?!?!?!?!

If you need more info, please ask.


"If you can't beat them, then hire somebody that can do it for you."

 

[CosmoKramer]

You called the Update or CancelUpdate method but didn't use the AddNew or Edit method before writing data to a record.

 

[Ma3x323]

All I did was scroll through the different records and when I was scrolling backwards, it gave me that error. Didn't update or anything. I wonder if it might be a coding error or I did not refresh the form or what.

 

[TTThio]

Well, if you are using a recordset, add
rs.Edit
'code in scrolling data
rs.update


However, if you don't intend to do any change or addition,
better use docmd.gotorecord to navigating through all records. Won't get such error.

 

[Guest_imported]

hi everyone

i hope someone can help with this problem. i have 3 comboboxes on a form where a person can select criteria to find a record. the record is found and is updated ok, but when a person selects the same customer name in a different region it updates the previus similiar customer record. any idea why 2 "like" customers in differenct regions or can not be selected after each other. i have used the me.requry before the find and this did not work.

 

[THoey]

mjc1, please start a new post... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.