Set Form's Visible Property to False

[cinders]

This seems really straight forward to me. I have 3 forms - FormA, FormB and FormC. When I open FormA the user inputs some information, when they tab to the last field, FormB opens (which I want to be invisible) and Form C opens.

I've tried putting this coding on the Open event of FormB:
Me.Visible = False

I've also tried putting this code on the Open event of FormC
Forms!FormB.Visible= False

Neither work. My form (FormB) still displays when eithr event occurs.

Any suggestions?

Cindy

 

[Rich]

Put it in the code on form A that opens form B

 

[jimbrooking]

If the issue is screen real estate, you might consider using the Tab Control to avoid the need for dancing among three open forms.

Jim

 

[cinders]

Put it in the code on form A that opens form B

Rich if I put the code in form A which opens formB (and will set its visible property to False) How do I write the code in form A and where do I put it? I cannot use Me.Visible = False I will need to code it...Forms!FormB.Visible = False, but what event to I put it on?

Any help you can provide would be greatly appreciated. As for using a Tab to hide it, it isn't a screen real estate issue. I need to have this cascading effect.

Thanks

Cindy

 

[cinders]

Actually I managed to get the visible property to set correct, but now I cannot get the focus to move to Form C.

I've tried setting the focus to itself on the onOpen event, but no luck.

Any suggestions?

 

[seiky]

put the focus on any control of the form C

like this : Form_formC.anyControl.SetFocus

 

[Mile-O]

As Rich said: use FormA to hide it as it opens FormB

i.e.

DoCmd.OpenForm "FormA", , , , , acHidden

Also, why such a strange method? Why all these forms appearing?