running macros from switchboard form

[TMcD]

When I run the macros from the main screen, they run just fine. But, when I try to run them thru the switchboard, the program either freezes or slows down so much the icons take about 3-5 minutes to re-populate the screen. I'm wondering about modules; but have no experience with them. Is there another solution I should try before delving into the world of modules?

 

[Rich]

What are the macros doing?

 

[TMcD]

There are 4 macros that each run 2-5 queries each that with a parameter gather data for a month, make a table, preform calulations, and then open a report for printing. Again, the macros work from the main window. But, is that just too much to run from a switchboard? I'd like to make it as easy for the end-user as possible; but if breaking it down is what I have to do....what are your thoughts?