Visibility of Forms

[spock1971]

Guys

I have a main form that I want users to populate before I reveal a sub-form. I've changed the 'visible' property to 'no' on the subform so it doesn't show by default but can't make it re-appear when I want it to.

I've tried the forms!whereform.visible=true code and it tells me it can't find the form 'whereform'.

Any suggestions?

Cheers

 

[Mile-O]

Your subform, since it is on your form, isn't a form you can just play with. It's a subform object. Use the name of the object and toggle it's visibility.

 

[le888]

Try this...

In your main form, put Me.subform name.Visible = False in the open form event. Then, create a button where you can put Me.subform name.Visible = True. So, each time you click on the button, the subform will appear.

Le

 

[carash77ash]

On main form:

on form_load set me.subform.visible = false

then on the control box that you want subform revealed set after_update
me.subform.visible = true

Ash

 

[spock1971]

Thanks all