Macro Open Form Argument

[access2010]

I have been following the same principals in using a Macro to open a form, but I am having a problem with this form.

Ctrl + Y = is not working.

Could I please be advised as to what was done wrong?

Thank you.
Crystal

 

[moke123]

Not a method I've ever seen before.

You have some sub macros without a named form. Delete some of the entries after the Control y subs.

this works.

 

[isladogs]

Autokeys macros can be very useful but its never a good idea to assign shortcuts that are standard Access/Windows shortcuts as you will overwrite that functionality
Whilst you have noted/excluded some of these, you have included others e.g Ctrl+A, Ctrl+H, Ctrl+Y, Ctrl+F12.
See this list of all Access keyboard shortcuts Keyboard shortcuts for Access (microsoft.com).

 

[access2010]

Not a method I've ever seen before.

You have some sub macros without a named form. Delete some of the entries after the Control y subs.

this works.
View attachment 91440

 

[access2010]

moke123, thank you for your suggestion which W.O.R.K.S.

Nicole​

 

[access2010]

Autokeys macros can be very useful but its never a good idea to assign shortcuts that are standard Access/Windows shortcuts as you will overwrite that functionality
Whilst you have noted/excluded some of these, you have included others e.g Ctrl+A, Ctrl+H, Ctrl+Y, Ctrl+F12.
See this list of all Access keyboard shortcuts Keyboard shortcuts for Access (microsoft.com).

isladogs, thank you for pointing me to something new, the list of Microsoft Macros.​

Nicole