Requery Form not Working

[r24igh]

Hi All,

I have a form that I want "refreshing" i.e. requerying to update the graphs that sit on it. I have the following but for some reason it's not working and I've tried multiple ways to solve - any help would be much appreciated:

Option Compare Database
Option Explicit
Public Sub RunExcelMacro()
Dim wb1 As Object
Set wb1 = CreateObject("Excel.Application")
With wb1
.Workbooks.Open ("StringforDB")
.Visible = True
.DoCmd.RunMacro (refreshallconnections)
.activeworkbook.Save
.activeworkbook.Close (True)
End With
Set wb1 = Nothing
End Sub
Private Sub Form_Activate()
Me.Requery
End Sub

 

[apr pillai]

Private Sub Form_Activate()
Me.Requery
End Sub

Try the following:

Private Sub Form_Activate()
  Me.Refresh
End Sub

 

[missinglinq]

I've never worked with graphs, before, so this is simply a guess, but if the 'not working' part refers to the graphs...try explicitly Requerying the Graphs; I suggest this because when you Requery a Form...Comboboxes are not Requeried...they have to be explicitly Requeried to update.

Linq ;0)>