Forms on Tabs updating other Tabs

I have an Access application that is basically one big tabbed interface, Sometimes information is updated on one tab that may affect other tabs. I'd like an event to requery certain tabs when they are selected. I've tried the on-click event for the tab and on focus for the 开发者_C百科form, but it is not doing it for me.

I'm using Access 2007 but I'm in Access 2000 compatibility mode (Is this a problem)

Which event should I be using to update the tabs? Some are display only.

TIA

That should be working. Switching to 2007 shouldn't affect how that works.

Are you doing the requery on the whole form, or on the individual combo boxes. e.g.,

Private Sub Combo10_GotFocus()
    me.Combo10.Requery
End Sub

You could also do something like putting a GotFocus on one of the fields in each tab (I can't remember, but I thought there was a default field that got focus whenever a tab is displayed).