Calling Procedure on other form

[Mike]

I have a Form that is set to visible=false while a save confirm Form is
displayed.

When the confirmation is complete the confirm Form is closed and the hidden
form is made visible=true.

snip....

gSaved = True

DoCmd.Close
Forms!frmMain.Visible = True

.... end snip

How can I call a public procedure that is contained withing the frmMain
module from within the procedure on the confirm Form.

Is it possible? should I make the procedure a Function?

Thanks

Mike

[John Mishefske]

Mike wrote:

I have a Form that is set to visible=false while a save confirm Form is
displayed.

When the confirmation is complete the confirm Form is closed and the hidden
form is made visible=true.

snip....

gSaved = True

DoCmd.Close
Forms!frmMain.Visible = True

... end snip

How can I call a public procedure that is contained withing the frmMain
module from within the procedure on the confirm Form.

Is it possible? should I make the procedure a Function?

Create a Public Function and call call it as so:

Forms!frmMain.setValue(gSaved)

where "setValue" is the name of your public function and gSaved is the value
you want to pass to it. Unless you are expecting a returned value you could
just make this a Sub instead of a Function.
--
'-------------------------------
' John Mishefske
'-------------------------------

[dingusmcgee]

if you want to keep the procedure on your frmMain form then refer to the
procedure after .Visible = True, something like....

DoCmd.Close
Forms!frmMain.Visible = True
Forms![frmMain].MyProcedure

hth,
dingus


"Mike" <re******@hotmail.com> wrote in news:3f******@dnews.tpgi.com.au:

I have a Form that is set to visible=false while a save confirm Form
is displayed.

When the confirmation is complete the confirm Form is closed and the
hidden form is made visible=true.

snip....

gSaved = True

>

... end snip

How can I call a public procedure that is contained withing the
frmMain module from within the procedure on the confirm Form.

Is it possible? should I make the procedure a Function?

Thanks

Mike

[Mike]

Thanks

"dingusmcgee" <di**********@yahoo.com> wrote in message
news:Xn********************************@207.225.15 9.7...

if you want to keep the procedure on your frmMain form then refer to the
procedure after .Visible = True, something like....

DoCmd.Close
Forms!frmMain.Visible = True
Forms![frmMain].MyProcedure

hth,
dingus


"Mike" <re******@hotmail.com> wrote in news:3f******@dnews.tpgi.com.au:

I have a Form that is set to visible=false while a save confirm Form
is displayed.

When the confirmation is complete the confirm Form is closed and the
hidden form is made visible=true.

snip....

gSaved = True

>

... end snip

How can I call a public procedure that is contained withing the
frmMain module from within the procedure on the confirm Form.

Is it possible? should I make the procedure a Function?

Thanks

Mike