"On" events not working??!

muttsylove

Registered User.
Local time
Yesterday, 16:30
Joined
Jul 30, 2005
Messages
10
Hi.. I'm terribly frustrated at this point and I hope someone can help shed some light on this.. I'm running into a very peculiar situation with using "OnChange" and other events (i.e. BeforeUpdate/AfterUpdate) for one of my forms. Not sure whether anyone has ran into this problem, but I had set "OnChange" event to occur for a combo box that I have. When tested, "OnChange" NEVER FIRES (when I actually selected a different value from the drop-down box). I thought I was using the wrong event, so I tried others (i.e. BeforeUpdate, AfterUpdate, LostFocus), to no avail.

Would anyone have an idea what may be wrong? Otherwise, I will need to create a command button for my users to click there so my actions can be done..

Thanks...!!!
 
Re read your post, you have not explained WHAT you want the combo box to do. You have only stated that is does not work.

Would anyone have an idea what may be wrong? Otherwise, I will need to create a command button for my users to click there so my actions can be done..
What action?

What do you want to happen when the combo "changes" (e.g.Open another form , update a textbox, find a record...what)?
 
The on Change event only fires when you type in a textbox and it fires for EVERY character that is typed so it has limited value. The normal event to use to do something after an item is selected from a combo or list box is the AfterUpdate event.
 
Hi Pat,

Thanks SO(!) much for your response and for your explanation. I used the AfterUpdate event and it worked perfectly (after figuring out an hour later there was a SECOND reason why it didn't work with the AfterUpdate!)

Turns out, my form has embedded subforms. I had only updated ONE of the subforms (and not the other!!), which caused me not to see the action happen. <<ggrr!!>>

(I inherited this database from someone, so you see my frustrations.. =D )

Thanks again!!!
 

Users who are viewing this thread

Back
Top Bottom