How to refresh a row source in a combo box from a query ?

[jeanpri]

Hello,

This is my combo box "Customer application" with the Row Source Type = Table/Query and Row Source = ApplicationQuery (a query which contains some predefined applications)



In the combo box "Customer application" I want to select the text proposed by the list (as you can see on the picture) or enter a new application (this is working).

The problem is when I enter a new application on the field, and I jump to another combo box "Customer application" this new application doesn't appear on the list, while the new application is right added to the query ApplicationQuery.

When I close and re-open the form the new application appear in the list. How can I do to make that a new entered application in the combo box appear instantly in the list without close and re-open the form ?

Thanks a lot !

Jean

[orange]

This should be helpful
http://www.techonthenet.com/access/c...esh_values.php

[jeanpri]

Thanks for the reply !

Interesting but it's not working: in VBA the function CustomerApplication.Requery is called each time there is a change (AfterUpdate).

(CustomerApplication is the name of my combo box and need to be refreshed each time there is a new entry).

[orange]

Can you post your mdb? Remove any confidential data.

[jeanpri]

Thanks for your help, I find the solution ! .Requery function works better at combo box exit.

So if you want to refresh the list in the combo box called CustomerApplication add this code in VBA:


Private Sub CustomerApplication_Exit(Cancel As Integer)
CustomerApplication.Requery
End Sub