Run-time error

jcaptchaos2

Registered User.
Local time
Yesterday, 23:03
Joined
Apr 28, 2011
Messages
12
I am getting a runtime error -2147352567(80020009) while using this code if the employee types a number into a combo box instead of using the scanner, is there a way to stop the error from popping up?
Code:
Private Sub Shop_Order_Number_AfterUpdate()
   Static abort As Boolean
    If abort Then abort = False: Exit Sub
    Op_Number = Mid(Shop_Order_Number, 6, 3)
    abort = True
    Shop_Order_Number = Left(Shop_Order_Number, 5)
    Item_Number = DLookup("[itemnumber]", "[shoporderstatus]", "[shoporderstatus]![shopordernumber]= " & [Forms]![Shop Floor Data Entry]![Shop Order Number])
End Sub
 

Users who are viewing this thread

Back
Top Bottom