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?

 

[disneygoof via AccessMonster.com]

I tried a nubmer of AfterUpdate code and I could not get it to work...I just
re-wrote everything differnetly...now I get what I want to happen

THANK YOU 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?

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

[quoted text clipped - 16 lines]

Thanks
D.