On Enter Event code won't run

[Roncc]

Hello all,
I am working on an inventory audit program and have run into a problem. I have a table named InventoryTbl that contains two fields QuantityInStock and AddItems . The QuantityInStock field contains the number of items (i.e. hairbrushes) currently in stock in the warehouse and the AddItems field is used to record the number of items to be added to the stock when purchased items are received. I have a form, InventoryAddtionFrm, with a table format, that contains both fields and which I use to record the addition of items. i want the QuantityInStock field to automatically update when I add items by placing a number in the AddItems field and have placed the code [QuantityInStock].Value = ([QuantityInStock] + [AddItems] in the On Enter event for the field AddItems but it doesn't work (the value of the QuantityInStock field does not change). I have found that when I place the code in the LostFocus event of the AddItems field the QuantityInStock field does update but I have to strike the Enter Key on my keyboard twice for it to work. Any suggestions on how to fix this problem?

Thanks for the help.

Ron Cheshier

[Roncc]

I found the answer to my problem. I placed the code in the After Update event for the field AddItems and it works fine. Problem solved.

[pbaldy]

Thanks for updating the thread. FYI, the On Enter event happens when first entering the control, not when hitting Enter. It's a common misconception. You found the correct event.