Auto-Runing a button on an ms access form

[PhatRam32]

I am trying to auto run two buttons I have on my Form when it loads upon opening the database.

Here is what I have tried so far without much luck (did not run anything). Any help would be greatly appreciated.

Items to note:

cmdRun and cmdExport's Subs are all set to public.

Private Sub Form_Load()

CmdRun_Click
CmdExport_Click

End Sub

other try:


Private Sub Form_Load()

Call cmdRun_Click
Call CmdExport_Click

End Sub

[June7]

Both Load and Open events work for me.

Step debug. Refer to link at bottom of my post for debugging guidelines.

[PhatRam32]

Just tried using the Open Event of the form and it did not work =/.

[June7]

Must be issue with code in the click events.

Debug as suggested.

[PhatRam32]

I will debug and see what I find and report back

[Missinglinq]

...Must be issue with code in the click events...

Having no problem making this code work, either, I'd have to agree that it must be something in the code behind the Command Buttons.

But just to make sure that we're not on a snipe hunt, here...do you have any VBA code in this database that works?

Linq ;0)>

[PhatRam32]

Yes the vba code behind the two buttons work like a charm. I will take a closer look though and see if there is something that is interrupting this process.

[PhatRam32]

I figured it out... My Macro settings for some reason got disabled.. which prevented me from running any VBA macros. The code I had posted earlier now works... silly mistake however, I appreciate the assistance.