View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Azza Azza is offline
external usenet poster
 
Posts: 7
Default Forms that open from forms

Hi there

I have a form that opens from a form with the other form remaining
open.

I use the form.hide command to go back to the original form, but it
does not go through the "initialize" code if I bring the form back up
and this is causing trouble.

How do I close the second form so that it does not close the first
form but initializes each time it is accessed with the first form
staying open

i.e: open form 1
open form 2 from a button on form 1
close form 2 - WHAT code to do this so that ..
open form 2 from a button the button on form 1
- form 2 opens using the initialize code.

using hide does only hides the form (dah-me) and then shows it when i
trigger the show code, but does not go through the initialize code - I
need to force the initalization each time.
cheers
Aaron