Requery Form

[raffi]

hi, i know the answer to this question is probably a simple one but oh well, is it possible to requery a form by clicking on the tabs posted below ?

[vicsaccess]

not anywhere i can find. access calls them document tabs.

[orange]

I was just working with a user that has a form with Tabs. There is a Click event that has
this code on each of the Tabs (Pages)

Function Refresh()
On Error GoTo Refresh_Err

    DoCmd.RunCommand acCmdRefresh


Refresh_Exit:
    Exit Function

Refresh_Err:
    MsgBox Error$
    Resume Refresh_Exit

End Function

Not sure if addresses your needs.

See this for more info.

[RuralGuy]

I've found the Click event to be useless. I use the OnChange event of the Tab control which fires when you change tabs.

[raffi]

this problem was partly solved by the following VBA within the Form Page.

Private Sub Form_Activate()
Me.Form.Requery
End Sub

its requerying subforms within the form but not the combo-boxes i guess i can manually add them one by one by just adding

Me.Cbobox.Requery

witin the Private Sub shell, o well thx for the reply's time and consideration

[Missinglinq]

...its requerying subforms within the form but not the combo-boxes ...

That's correct...Requerying a Form doesn't Requery its Comboboxes...they have to be done separately.

If you have a number of them on a Form that have to be Requeried at one time, from the Form's Code Module you can do something like this:

Dim ctl As Control

For Each ctl In Me.Controls

       If ctl.ControlType = acComboBox Then
           ctl.Requery 
       End If

Next ctl

Linq ;0)>