Access 2000 - Assign code in Modules to button
Posted on 2011-03-21
I have some VBA code lines in Modules section, those I would like to assign to button, that pressing it would be executed so run.
But if I put the module name as button property as Hyperlink SubAddress, the Access just open the module in design view and not run. Similiar the case if I put the module to a macro as OpenModule action, it opens the code in design but does not start the run of it.
Could you please advise what is the method of it?
Basically if I would like to open a query by a button, I used to apply those two ways above