Keep getting error trying to save a record in ms access VBA -


i kept getting error me.dirty = false or docmd.runcommand accmdsaverecord. me.dirty = false 'invalid property', , docmd error 2501.

after experimenting tried me.refresh command before save command, , error stopped occurring.

i'm sharing in case else gets sticky save error (especially if goes away after press f5 in debugger) - put me.refresh command before save , might out.

also if knows why refresh before save fixes it, i'd interested.

ps: - history - after noticed if pressed f5 in debugger after got error, record did saved on retry no further errors.

then tried putting dialog box user in on error handler resume retry save, , after clicked ok record saved , error did not recur.

that's how guessed refresh might help, since dialog forced kind of refresh. kind of wild guess, worked.

you can't assign true me.dirty, because me.dirty read-only variable. command docmd.runcommand accmdsaverecord can executed if form dirty. this:

if me.dirty    docmd.runcommand accmdsaverecord end if 

if answer doesn't help, should post code. can see other things may lead error.


Comments