Changing sub-forms on the same form?

[cartleman]

Is it possible to change which subform is displayed by pressing a button, on the same form?

Each subform is based on a parameter query if that has relavence.

 

[supercharge]

In your button's onclick sub, change your subform's SourceObject to whatever subform's name.

    subfrmMenu.SourceObject = "subform's name goes here"

 

[CEH]

Subforms also have a "visible" property. Set it to No and on the OnClick event of your command button "subform.visible = true"

 

[cartleman]

In your button's onclick sub, change your subform's SourceObject to whatever subform's name.

    subfrmMenu.SourceObject = "subform's name goes here"

I don't quite understand. I'm a newbie to VB, sorry!

The wizard make a form open "on click", but I need a subform on the same form, which it can't do...

 

[supercharge]

Here you go, a small sample, created just for you.

 

[cartleman]

I need parameter queries - take a look.

 

[supercharge]

Ok, now try it.

 

[cartleman]

Ah you beauty. So so so simple.

Shame the result query thing is so ugly and grey I cant change this can I...

 

[alastair69]

Ah you beauty. So so so simple.

Shame the result query thing is so ugly and grey I cant change this can I...

Have a mess about with the forms attached is an updated copy

Click here http://www.braeburn1.demon.co.uk/Database/MySubForm.zip Here to help

 

[supercharge]

You mean you didn't know which attachment was the most updated one?

Thanks for sharing.

 

[cartleman]

Eh?...

Anyway, excellent. Exactly what I was after.