ComboBox: Update a value in current record before changing the ComboBox Value

[disneygoof via AccessMonster.com]

It's been a while since I have had any issues...I seem to create my own
problems...

I have a combo box in a sunform. I use the combobox to choice multiple items
in the subform. When I pick and item in the combobox, I run an AFTER UPDATE
and set a value in a table (I change a 0 to a 5). However, if I picked the
wrong record and go and change it to a different record, the value I set to 5
above stays a 5 and know I have a record with a value I do not want...I want
to change it back to 0 before I change the record in the combobox. I have
tried Before Update, On Enter, On Get Focus...these don't work...

Why do I do this...later in the Main form I click a button that runs a few
sql queries and they look at the value in the table and perform tasks...which
all works very well!

So, how can I change the current record value, before I update the combobox
to the new record...

Thanks
D.

 

[miss031]

Would the AfterUpdate code not run again if you change the value back to the
correct one, and successively each time you change it?