Open a form in a subform depending on button.

[james]

Hi
Sorry this is probably really simple but for the lfie of my can't find how
to do it.

I have a form with three buttons and an Unbound subform.

I would like that when I click one of the buttons it opens another form in
the currently unbound subform.
I can work out how to open a form in another window but I want it to open in
the subform.

Also If I wanted it to open a query instead of another form in this subform
would this change much?

Thanks
James

 

[Tom van Stiphout]

On Fri, 20 Nov 2009 03:37:02 -0800, james

Me.mySubformControl.SourceObject = "mySubform"

Yes. That is impossible. Use a subform in datasheet view instead.

-Tom.
Microsoft Access MVP