How do you link a button with a macro that you created in Access. I have the button saving my data to the table but I also want the button to activate my macro. I am not good with the script editor and tried to modify the code with no luck.

I need help writing the code to execute the macro in the data access page. I created the page using access.

Thanks for any help,

Eric

I should also tell you that I am trying to use the button in a Data Access Page. It will be put on our server for multi users to access. I can create the button to work in the form but I can't get it to work in the web page.

Thanks,

Eric

Hi, I also am having troubles doing this. I have created a macro which runs a report and would like to create a command button on the data access page that runs the macro...I have tried a few methods, one, converting the macro to vb and copying/pasting that code to the command buttons's on-click event, all of which have failed for some reason. Anyone?

Did any of you find a solution to this one? Please post, thanks! :)