Linking a Module to a Macro in Access

[JoeRooney]

Hi,

I am new to access and I would like to find out how to linka module to a macro so I don’t have the run the module through VB.

The module is working fine but I can’t figure out how tolink this to either

1. A macro so I can run it from the Database tools tab
   
2. Assign it to a button on a form.

Any help on this is greatly appreciated.

Thanks,

 

[Trevor G]

Add a button onto a form, then look at the properties of the button and use the Event On Click use the ellipsee button and select VBA, then use Call and the subroutine name from the module sheet and save close the VBA screen down change the view of the form and you should beable to run the code from the button.