Run a VBA function from Access button

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


  • Hi,

    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.

Howdy, Stranger!

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


In this Discussion