Calculated field in Combobox Not Updating

[LemonRawr]

Hi,



I have a combobox that is populated from a query that has a calculated field. I am trying to use an after update code to requery my combo box so that the calculated field get updated when enter in a new number. However, the calculated field in the combobox does not update with the new number until I change the record. I think I am doing it the wrong way.

I have it setup as follows:

Combobox name: OrderNumber
Query Name: OrderData (has a calculated dsum field that adds up all the quantities based on the order number)


Afterupdate_quantity code
me.ordernumber.requery

[pbaldy]

If it updates correctly after you change records, you likely need to force a save of the record before the requery.

If Me.Dirty Then Me.Dirty = False