need code for VBA in access for a refresh button

[firemanjr]

I have a data entry form "FrmCliententry" that has a field city(combo box), that field is based on a table. If the city is not in the list a subform comes up to enter the new city name.
When the subform closes I want to refresh the main form so the new city appears in the combo box
Thanks

 

[PHV]

Can you please post the whole code of the NotInList event procedure of the combo ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Tivoli0]

Try this:

Private Sub city_AfterUpdate()
Me!city.Requery
End Sub


Private Sub city_Change()
Me.Refresh
End Sub

Tivoli0