Subform control OnClick firing

[alex]

Subform control OnClick firing

Hello all,

Using Access ’03…

I have a form that opens on startup.

Once the form loads, it opens another form as a popup.

The popup form has a subform with only one piece of code, which is in
the on click event of one of the controls (the control is a hyperlink
that opens another form).

What’s described above works fine, but on occasion (not always) the on
click event of the subform control will fire when the popup is
opened. I thought the subform may be getting the focus and then
unintentionally firing, but even when I set the focus to pop up form
and not the subform, it still happens.

Anyone have any ideas as to what may be causing the code to execute
without an actual click of the control?

Thanks,
alex

 

[alex]

Subform control OnClick firing

Hello all,

Using Access ’03…

I have a form that opens on startup.

Once the form loads, it opens another form as a popup.

The popup form has a subform with only one piece of code, which is in
the on click event of one of the controls (the control is a hyperlink
that opens another form).

What’s described above works fine, but on occasion (not always) the on
click event of the subform control will fire when the popup is
opened.  I thought the subform may be getting the focus and then
unintentionally firing, but even when I set the focus to pop up form
and not the subform, it still happens.

Anyone have any ideas as to what may be causing the code to execute
without an actual click of the control?

Thanks,
alex

Not sure if this helps troubleshoot...
The code behind the ctl seems to only fire (erroneously) when I open
the db by bypassing startup; i.e., open the form (startup form)
manually. If I click on the the file (not bypassing startup) the code
behind the control will not fire unless clicked.
Too strange!