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



  • 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()
    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?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!