COMBO BOX DOESN'T REFRESH?

[Angelique]

Thanks MichaelRed with your suggestion but it already has its LimitedtoList property set to True.

When I close the Client form it puts the focus on the combo box in the dropdown position but the new entry isn't there. If I select any one randomly and there key back to the combo box, there it is!

Control Source: InvoiceDetails.ClientID
Rown Source: qryInvoiceClientSorted
Bound Column: 3
LimitToList: Yes
Combo After_Update()
Me.combo box.requery

Why is this so?? this is driving me crazy, it should work.

Angelique

 

[LonnieJohnson]

I don't know the whole story, but it sounds like you are moving from one form to another. And the form you are moving to has a combo box that a value has been added to. If this is the case try requerying the combo box from the form that you are closing:

Forms![FormName]![ComboBoxName].Requery ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[Angelique]

Guess what, when I close the called form, I have the syntax in the Close Form button! so any other suggestions?

Angelique