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.

--
David (Disneygoof)

Message posted via http://www.accessmonster.com

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" wrote:

> 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.
>
> --
> David (Disneygoof)
>
> Message posted via http://www.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

miss031 wrote:
>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.

--
David (Disneygoof)

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...oding/200803/1