Refreshing tab control

  • Thread starter Thread starter Przemek
  • Start date Start date
P

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
 
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.
 
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
 
Back
Top