on_current event causes problem with IE

[Andrew]

Hi,

I've created an access database that has a form with the on_current event.
That form is set to startup when the database is opened. When I try opening
the database with IE, the form will not display, and it seems like there's a
deadlock somewhere. The form will display if i take out the on_current event
(but that would mean I cannot do what i need to do) or if I don't set the
form to startup when the database loads.
Anyone heard of this problem or know how to solve the problem? I'm using
access 2000 SP3 (was sp1, but patched it just last friday to see if the
problem still occurs with sp3) and IE 6 (latest version also).

And the problem is not with the particular database I was working on. I can
reproduce the problem by creating a simple database. as long as the database
has a form_oncurrent event, and is set up to startup when the database is
opened, then i won't be able to display the form
with an html link.

Thanks

Andrew

 

[Kelvin Lu]

How about moving the code to OnLoad() instead.

 

[Andrew]

After trying a few stuff, I think the onload will cause the same problem as
well. On_Activate, On_Open will (if I remember correctly). Anyway,
On_Current is different from On_Load, so moving my code from On_Current to
On_Load will not do what I need to do.

I've found a way around the problem, and that is to set the form to Popup
and Modal. But I still prefer the form the way it was.

Thanks for you suggestion

Andrew