Tab Form query problem

[Zako]

Ive been searching through these forums and see some people asking similar questions, but I cant find one that really tells me how to do my specific question.

I have a form called "frmMain" that has 4 tabs. Each of the 4 tabs has a SubForm that contains one of 4 other forms I created.

Right now I would just like to deal with the first 2 tabs:

In Tab 1 I have a subform linking to "frmVM"
In Tab 2 I have a subform linking to "frmOpen"

What I need, is a way to refresh the data in the subform (requery??) when the user clicks the tab for that page.
i.e. User clicks "Tab1" the subform re-does its query to get the current data for "frmVM"

I made a command button in the Tab1 that does the following:

Private Sub Command31_Click()
Me.sbfrmVM.Requery
End Sub

"sbfrmVM" is the name of the subform in that Tab1. This command button does cause the form to requery and I get the latest data. What I would like, is for this to happen automatic when the user clicks the tab.

 

[Idjit]

Put the code in the tab page's "On Click" event property.

 

[Zako]

I tried that actually... and for some reason it had no effect. I ended up getting it to work by using the "On Enter" event for the subform.

Thanks for the reply!