auto populate list-box on form

Hi All

I have a form where the user enters a cost centre. Depending on the cost centre selected, I want the "approver" list box to get auto populated with the appropriate approver for that cost centre. There is a table in the db that has an approver for each cost centre.

If anyone can suggest a solution to having the approver populate the list box as soon as a cost centre is selected, I'll be vry thankful

Cheers

Johnny

Re: auto populate list-box on form

hi guys

i have used this bit of code, and it sort of has the right effect:

Private Sub Send_To_AfterUpdate()
Me.Send_To.Requery
End Sub

The only problem is that i have to click the list box selection, after which i have to click it again to update.......

Is there a way to make it auto refresh?