requery

[samer]

I have this form with two fields, first one combo box which I'll pick
Record from; depending on it the second field which is a query that
Will run on enter. For example:
Reg time: 10 – 12 (combo box record)
Lab time: 10 – 11 (query)
But what if I decide to change the reg time field to:
Reg time: 12 – 2
Lab time: ??????
which must be 12 - 1
How to refresh the query to give new lab time ?

 

[sonny]

Try something in the after update of the one that your changing, the vbNullString clears out the old data...

Private Sub YourCombo_AfterUpdate()
Me.YourCombo2 = vbNullString
Me.YourCombo2.Requery
End Sub

 

[samer]

Try something in the after update of the one that your changing, the vbNullString clears out the old data...

Private Sub YourCombo_AfterUpdate()
Me.YourCombo2 = vbNullString
Me.YourCombo2.Requery
End Sub

Sonny, thanks a lot for help, it was a kind of you. I have use it
A lot in my project.