Combo box event only works once

[EddyLLC]

I have a combo box whose value is derived from a value list. Behind the After Update I have an event procedure that references the value in the combo box with data in another table. The first time I put data in the combo box the code executes fine. If I then immediately change the value in the combo box the event procedure does not fire at all. I put a stop in the code behind the event procedure to verify this.

Why would the event procedure only work once? Thanks

 

[Zygor]

Have you tried a requery?

 

[EddyLLC]

Thanks for the response. I did try the requery. Same result, maybe because the data for the combo box is provided from a value list and not a query? I don't know but same result. The event won't fire a second time unless I leave the form and come back.

 

[Zygor]

can you provided the code that supplies the rowsource?

and what event are you using?

 

[EddyLLC]

These are the values enumerated in the row source. There are more listed but you get the idea. There are two columns with headings so the first two entries are headings.
"Number";"Title";"1";"Shadow Divers";"2";"Alice in Wonderland";"3";"The Godfather"

I am using the AfterUpdate event. I tried the On Change event but if there was a value in the combo box and I deleted it the code ran but believed there was data in the combo box when in fact I deleted it.

 

[Zygor]

Try the on Change event

 

[EddyLLC]

Bingo! Works great. Thanks for the help.