Undo selection change to combo box

[merry_fay]

Hi,

This is difficult to post code for as it's involving lots of different calls & events so I'll try & explain:

I have a form which has a combo box (source field: [SName]) to filter it.
Users can then make changes.
The combo box has an AfterUpdate event for:
strComboSelection=me.combobox
(strComboSelection defined as a string for the form)

When they go to Exit the form OR to change the combo box, I need to run a check to make sure the percentages for the selection still add to 100%

I can't get a sum of the percentage box on the form to update (recalc & refresh don't work in my access (2003)) so I'm doing a query to sum the percentage where [SName]=strComboSelection.

To get this to work I need to requery the form.

If I set this check on the gotfocus event for the combo box, I can't change it as it constantly runs.
For any other event it runs too late -after the user has changed the contents of the combo box.

So, am I missing an event -one where I can requery & still use the combo box OR is there a way to 'undo' the change to the combo box?

Hope this makes sense!!!
Thanks

 

[merry_fay]

Solved -I put an after update event on the percent text box to save the record