"On" events not working??!

[muttsylove]

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...!!!

 

[ansentry]

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)?

 

[Pat Hartman]

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.

 

[muttsylove]

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!!!