I have several queries that I have put on various form tabs what I need to achieve is each time i click on a form tab it re runs the query to show the up to date information. I hope this make sense!

On the tab control's ON CHANGE event, requery the controlsource of your subform. For example,

Select Case Me.ctlMyTabControl
    Case 0
        Me.sfrMySubForm0.Requery
    Case 1
        Me.sfrMySubForm1.Requery
    Case 2
        Me.sfrMySubForm2.Requery
End Select


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division