Chart problems with Access Office 2007

[Kirk Groome]

I'm working with a split database that's been running with Office 2003 with
no problems.

Among the (many) problems encountered in getting it to run under 2007 is one
with charts. With 2003 all charts displayed after programmatically loading
the row source of the OLEObject.Frame. Even adding Me.OLEObject.Requery, the
chart will not display. If it's ona a Tab, going to another tab and back
usually will display it. Another workaround is to click or double-click the
chart, in other words, to give it the focus.

Only happens with 2007, not 2003. Sample code snipit is below
--------------------------
gsYear = cboYear
If bTab0 Then
Me.OLEUnbound0.RowSource =
Replace(QueryMOD_QueryGet(QRY_CHTSALESYTD), "2006", gsYear)
'Added next 2 lines for Office 2007 - still doesn't display chart -
need to click it
Me.OLEUnbound0.Requery
Me.Requery
End If

Any help for early Office 2007 adapters would be greatly appreciated.

David Groome
MicroMetric, Inc.