How can I run a function that I wrote in VBA code in a standard module. I would like to run it from a button on the Access forms page. I tried creating a macro to run it but the macro cannot seem to find the code.
Anyone got any ideas.
Thanks for your help
Comments
Create a new form and add a button control. Go to the button properties and select the "Event" tab. Select [Event Procedure] next to "On Click" and click (...) to open the VB module.
Private Sub Command0_Click()
'your code goes here..
End Sub
Hope this helps!
-Jaime
http://www.programmerssolutions.com