Refreshing tab control


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
 
Ad

Advertisements

K

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.
 
Ad

Advertisements

K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top