I have an Access database and I'm currently a dynamic switchboard menu system, which has a table to lookup which report, form,to run and then run it. Its fairly simple by using Docmd. Openreport or openform, with rhe report or form from the table run as a parameter.
I find myself in the situation where I need to be able to call a VBA function (with parameters) from this menu. is there the equivalent of a docmd.openreport equivalent which allows the calling of procedures. I'm familiar with the macro runcode, but I'm not sure if/how it is possible to pass arguments to it dynamically.