Save macro not working in Office 365

[TattyFran]

Hi



I need to be able to create a Save macro for a form using the macro builder. In the past I've successfully done it using RunMenuCommand and then selecting SaveRecord

This now gives me an error

'The command or action 'Save Record' isn't available now'
The error number is 2046 with arguments 97

Interestingly, when I use the wizard to create a save button on the same form, then open the created macro and cut out everything apart from the identical command, it works fine.

We use Access 365 but I think we were using this previously. Has anyone any ideas what's going on?

I need to be able to make the macro using the builder rather than VBA for educational purposes, please don't suggest code solutions as I won't be able to use them

Many thanks!

[Bob Fitz]

Perhaps your existing button control is corrupted. If you insist on using macros, why not just use the wizard to create a new button and delete the old one.

[TattyFran]

Hi,

Thank you so much - you have helped me solve the problem, although I don't understand why!

Basically, the macro that produces the error was built in macro builder without an attached button. I usually build macros first then attach them to buttons later (just a habit from teaching to help my (young) students understand that macro =/= button) Other macros relating to forms work fine when tested by running them without a button,

As part of my troubleshooting I tried the button wizard as an experiment to see if it used the same macro commands, which it did.

HOWEVER I have now added the macro code to a button on the form, and it no longer produces the error. I don't understand why, to be honest, but I am very grateful that you have led me to the solution