Thanks... I did remove "If frmName < ""frmPhysical Then Exit Sub", now
everything works fine.
Thanks again!
Craig

"Leith Ross" wrote
in message ...

Hello Craig,

Since you are not calling Update_Inventory from any of the other Forms,
you can remove "If frmName < ""frmPhysical Then Exit Sub" from the
code. I added this as a troubleshooting aid iin case Update_Inventory
were being called from other Forms.

I had asssumed the TextBoxes were directly on the Form. The Parent
property returns the object that holds the TextBox. Since it is a
Frame, the code returns the Frame name, not the Form name. Remove the
If statement and it should work.

The *After_Update* event fires once the user presses enter, or clciks
on another control. If your code is still returning the correct result,
there is a problem somewhere else in the program.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=482515