Runtime Error '2046' ... "SaveRecord" is not availble now

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tsuki - 09 Mar 2005 06:03 GMT

I have an access 2000 database that I just inherrited. Everything has been
working fine until today. I have a subform that has a drop down list that
after performs the follwoing:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

it is at this line that I encounter the runtime error '2046' The action or
command 'SaveRecord' is not available now.

I have debugged and debugged and am at a loss... Why would this "all of a
sudden" start to occur? What could I have possbly have done that would cause
this to break?

Any insight or advice would be greatly appreciated!
Thanks

Reply to this Message

Tsuki - 09 Mar 2005 06:33 GMT

So I jusr tried the
If Me.Dirty = true then Me.Dirty = fals
trick and it worked.... but I am still curious as to why?

Thanks again

> I have an access 2000 database that I just inherrited. Everything has been
> working fine until today. I have a subform that has a drop down list that
[quoted text clipped - 10 lines]
> Any insight or advice would be greatly appreciated!
> Thanks

Reply to this Message

Geoffs - 09 Mar 2005 10:27 GMT

Hi Tsuki,
Are you getting this message whilst you are in "Break" mode debugging? If so
then that is why, you cannot run that command in Break.
If not, try "DoCmd.RunCommand acCmdSaveRecord" - that is the MS preferred
method, the other method is for backwards compatability.

:-)

> So I jusr tried the
> If Me.Dirty = true then Me.Dirty = fals
[quoted text clipped - 16 lines]
> > Any insight or advice would be greatly appreciated!
> > Thanks

Reply to this Message