Connecting Tech Pros Worldwide Forums | Help | Site Map

Change Focus triggers Before Update

Thelma Lubkin
Guest
 
Posts: n/a
#1: Nov 13 '05
....when I don't want it to. If user types into comobobox window and
then decides that that's not what s/he wants to do and changes focus
to another control, I don't want the code in Before_Update event
performed, but that's what is happening. How do I disable such
behavior?
thanks, --thelma




Rick Brandt
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Change Focus triggers Before Update


"Thelma Lubkin" <thelma@alpha2.csd.uwm.edu> wrote in message
news:dfqjok$9l5$1@uwm.edu...[color=blue]
> ...when I don't want it to. If user types into comobobox window and
> then decides that that's not what s/he wants to do and changes focus
> to another control, I don't want the code in Before_Update event
> performed, but that's what is happening. How do I disable such
> behavior?
> thanks, --thelma[/color]

BeforeUpdate of what? The ComboBox or the Form? The latter should only fire if
leaving the control is also triggering a save of the record (something it won't
ordinarily do). BeforeUpdate of the ComboBox will fire before the LostFocus of
the ComboBox and there is nothing you can do about that.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Closed Thread


Similar Microsoft Access / VBA bytes