form open event and screen.activeform

[rmanchu]

hi

i've got a few forms which are backed by ado recordsets and i load them
on the forms OnOpen event via vb code in a common module.

to clean the form module code, i added the following line to the top of
the code and had it called via macro, instead of passing "me" to the
code.

if frm is nothing then set frm = screen.activeform

however, at the time of the OnOpen event, it seems that
screen.activeform <> to the form being opened!

so is there a way to get the form being opened, in vb code, when called
from the OnOpen event of that form?

thanx
riyaz

 

[Allen Browne]

Pass Me.

You can't miss.

If you are trying to call a generic function without using the form's
module, use the form's Form property:
=MyFunction([Form])

 

[rmanchu]

hey

i completedly missed that. thanx!