automate Exports for every 5 minutes

[jmeckley]

I need to export 3 files from access the exportation works, my problem is automating this export to occur every 2 minutes. i looked at Access Help and from what they have told me i now have the following code in place:

***********************************************************
Private Sub Form_Load()
'Export Information every 2 minutes
Me.TimerInterval = 120000
End Sub
***
Private Sub Form_Timer()
'variables
'Export code
End Sub
***********************************************************
I open the form, but nothing happens. What part of the code am i missing?

thank you for help Jason Meckley
Database Analyst
WITF