How can I call Return or ClickEvent from macro

[gellerche]

I have an Access application that I want to run by itself after hours. I've gotten it to the point where the application opens on schedule, and then goes to the macro. The macro opens the necessary form, fills in the values the form needs, and gives focus to the Submit button. The only step I CAN'T figure out is how to click the Submit button from the macro. I've tried SendKeys Action with {Enter} as the Keystrokes, but it doesn't work. If anyone knows how to click the button (or how to call the Sub associated with that button's ClickEvent), I would appreciate the help.

Thank you,

Steve Geller

 

[Mario]

can you do this:

Once you are at the point where you want your button to be clicked, just insert a call to the sub in your code, ex:

call ClickOnButtonEvent

 

[gellerche]

Thanks, Mario! I did wind up using a similar setup.