I need help with cascading combo boxes

[Guest]

OK, I am having problems with refreshing when I go to the next record. This
is what I have:

2 unbound Combo boxes cascading.
When I click on the next record, I want the combo boxes to reset to blank
combo boxes. They don't, they stay at the last choise that was made when I go
from record to record.

What VB do I need to enter for this function to activate?

Currently I have:

Private Sub RegionName_AfterUpdate()
Me.CityName = Null
Me.CityName.Requery
Me.CityName = Me.CityName.ItemData(0)
End Sub

Now this I found only resets for next use, but I need it start blank again
in the next record.

 

[Ken Snell [MVP]]

Try using the form's Current event to set the combo box value to Null.