Close & Open form with code

[Guest]

I just converted a macro to code using the convert utility. Of concern are
just two lines in the macro: OpenForm and CloseForm that work fine in the
macro.

When the form opens, OnActivate makes some makes some comparisons and calcs
that are used further down the macro after the form is closed. When I
convert those two lines to VBA, the form won't close-just opens, does its
calcs and stays there.

I changed the form caclcs to OnClose, the form then closes ok but the code
stops as if I insersted and End statement. What am I mssing? Thanks for any
help.

 

[missinglinq via AccessMonster.com]

You really need to post your code for us to help.

I just converted a macro to code using the convert utility. Of concern are
just two lines in the macro: OpenForm and CloseForm that work fine in the
macro.

When the form opens, OnActivate makes some makes some comparisons and calcs
that are used further down the macro after the form is closed. When I
convert those two lines to VBA, the form won't close-just opens, does its
calcs and stays there.

I changed the form caclcs to OnClose, the form then closes ok but the code
stops as if I insersted and End statement. What am I mssing? Thanks for any
help.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[John Vinson]

I just converted a macro to code using the convert utility. Of concern are
just two lines in the macro: OpenForm and CloseForm that work fine in the
macro.

When the form opens, OnActivate makes some makes some comparisons and calcs
that are used further down the macro after the form is closed. When I
convert those two lines to VBA, the form won't close-just opens, does its
calcs and stays there.

I changed the form caclcs to OnClose, the form then closes ok but the code
stops as if I insersted and End statement. What am I mssing? Thanks for any
help.

You don't show your code, so it's hard to be sure - but if you open
the form in Dialog mode, your code will stop until the opened form is
closed or made invisible.

John W. Vinson[MVP]