Submacros in Access

[Lee73]

Go easy on me. I know little to zilch on Access. I have completed a database with tables and queries, and have completed autoexec macro. Now my teacher has asked me to do a submacro. I have no idea how to go about this. He gives no information, as he has said, Other people have figured it out, so should you. Can anyone guide me to WHERE I can find this info? I am using access 2007

 

[xenou]

There is no such thing as a submacro, leastways that I have heard of.

He/she probably means a vba subroutine -- essentially, writing something in a code module rather than using the Macro wizards.

Another possibility is a macro that calls another macro, perhaps ... ???

 

[Lee73]

Ok, I appreciate the response. He sent me a word document stating: Each key assignment is a submacro. Create a submacro by double clicking submacro under program flow. Yet 2007 version does not have this. Or does it? am I just missing it? Can I create key assignments a different way?

 

[Joe4]

From what I can see on-line, it appears that "submacros" did not come about until Access 2010 or 2013.
https://msdn.microsoft.com/en-us/library/office/ff837173.aspx
https://www.youtube.com/watch?v=_ryFjbMcUsA

 

[Lee73]

Thank-you! then I'm not crazy/dumb. I will have to access another computer then for my assignment, as I only have 2007. Thanks for reply.

 

[Joe4]

That YouTube link I posted has a good demo/introduction into SubMacros. So hopefully that will help you with your task.

 

[Lee73]

perfect! will definitely be watching!