No, the events isn't trigged when you change the values using VBA or by Lookup fields, you need physical touch with the control, it is the way MS-Access worksThe situation is that when a user enters something in the cboItemName combo box, the last Category used for that item auto populates in the cboCategoryName combo box. When that happens I expect that the AfterUpdate event or the OnChange event would trigger.
Yes that helped a lot.In the attached screen shots you will see some examples that I hope will help visualize what is (not) happening.
I've modify your code a little, (database attached), try if the result is what you want, else post back!
Attachments
Last edited: