Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Run a VBA function from Access button

genesysrgmgenesysrgm Member Posts: 1
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


  • jaime777jaime777 Member Posts: 17

    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!

Sign In or Register to comment.