Refreshing tab control

[Przemek]

Hi,

I have a form with combo box and multi page tab control with many
controls bound to my query. Query is based on value chosen from combo
box. How can I force controls to requery if user choose different
value from combo box?

Przemek

 

[Klatuu]

Use the After Update event of the combo

With Me
.txtBozo.Requery
.cboFoo.Requery
End With

Just requery all the controls that need to be requeried.

 

[Kipp Woodard]

In the after-update event of the combo, all you should have to do is requery
the form.

Private Sub Combo3_AfterUpdate()

Me.Requery

End Sub