How do I? : Control Positioning of Subform when switching?

[thefarg]

I have a form with a subform frame in it. Using

Me.MySubformFrame.Form = "MySubForm1"

works but the subform open outside of the frame. Top left corner in fact. Any ideas on why this is happening and how I can solve it?

Thanks
Mike

 

[thefarg]

Currently, Im using the following code as a workaround.

Dim SubformTop As String
Dim SubformLeft As String
SubformLeft = sbfSalesPivot.Left
SubformTop = sbfSalesPivot.Top

            Me.sbfSalesPivot.Form.Visible = False
            Me.sbfSalesPivot.SourceObject = "frmHome_SalesAnalysisSubform4"
            sbfSalesPivot.Top = SubformTop
            sbfSalesPivot.Left = SubformLeft
            Me.sbfSalesPivot.Form.Visible = True

It appears to work fine, but its a messy way to do it. Can anyone help with the problem of the subform escaping its frame?
sldGraph.Tag = 4

 

[dhookom]

thefarg,
Again unconventional request without providing context. I have never heard of a subform changing Top and Left properties without code changing them.

I would expect you should be using:

Me.MySubformFrame.SourceObject = "MySubForm1"

The top and left properties are numeric, not strings. Try to conform like:

Dim lngSubformTop As Long
Dim lngSubformLeft As Long
lngSubformLeft = Me.sbfSalesPivot.Left
lngSubformTop = Me.sbfSalesPivot.Top

Duane
Hook'D on Access
MS Access MVP

 

[thefarg]

Ok. Any idea why the subform moves? Im just trying to switch the graph on the main form "Home" on the Northwind 2007 db.