TimerInterval not working

[caris111hk]

I have an access db application which needs to call the macro on
startup. The macro is to call the function opening two forms on
startup and set the TimerInterval of two forms.

Public Function auto_login()

DoCmd.OpenForm "frm_A"
Forms![frm_Import&Export].TimerInterval = 300000
DoCmd.OpenForm "frm_B"
Forms![frm_TREATS_ftp].TimerInterval = 120000

End Function

However only the Timer for form B (at the toppest) works. It works
for form A but not B if I open form B first and then A later. Is
there any way to solve the problem?

Regards
Caris

 

[Guest]

Caris,

This seems a litle simplistic, but I'm not sure why you are opening "frm_A"
and then setting the timer interval on "frm_Import&Export".. Have you tried:

Public Function auto_login()

DoCmd.OpenForm "frm_A"
Forms![frm_A].TimerInterval = 300000
DoCmd.OpenForm "frm_B"
Forms![frm_B].TimerInterval = 120000

End Function

--
Email address is not valid.
Please reply to newsgroup only.

I have an access db application which needs to call the macro on
startup. The macro is to call the function opening two forms on
startup and set the TimerInterval of two forms.

Public Function auto_login()

DoCmd.OpenForm "frm_A"
Forms![frm_Import&Export].TimerInterval = 300000
DoCmd.OpenForm "frm_B"
Forms![frm_TREATS_ftp].TimerInterval = 120000

End Function

However only the Timer for form B (at the toppest) works. It works
for form A but not B if I open form B first and then A later. Is
there any way to solve the problem?

Regards
Caris