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
 

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

Similar Threads

2007 Multi Value Check Box Lists 1
Access Form - Lock Fields from Editing 0
Form defaults to a different record when updated. 2
Requery Form from Combo Box 3
Combo Boxes - DISPLAYING multiple fields after choice is made 5
Tab Controls 6
SubForm in Tab Control Not Refreshing 3
combo box selection will not populate query correctly 1

Back
Top