I have a form that's used to ship out barcoded elements.
The Main Form is the transaction information (shipping to/date of etc), and the subform is the list of barcoded element(s) to be shipped (barcode #, media details, check box (indicating the item is out-of-house)).
In the past I've just manually updated the check box after entering the barcode number in the subform; however, I'd like to begin hiding the check box on the form and having it change value (from 0 to -1) for every barcode that's entered onto the shipper. (hopefully this makes sense!
)
I've tried entering the following code into:
But I get a runtime error '3164' - Field cannot be updated. ...and to be honest I'm just shooting in the dark with the code.
Any help would be greatly appreciated.
Thanks!
Matt
The Main Form is the transaction information (shipping to/date of etc), and the subform is the list of barcoded element(s) to be shipped (barcode #, media details, check box (indicating the item is out-of-house)).
In the past I've just manually updated the check box after entering the barcode number in the subform; however, I'd like to begin hiding the check box on the form and having it change value (from 0 to -1) for every barcode that's entered onto the shipper. (hopefully this makes sense!

I've tried entering the following code into:
Code:
Private Sub barcode_m2m_AfterUpdate()
Me.ShippedOut.Value = -1
End Sub
But I get a runtime error '3164' - Field cannot be updated. ...and to be honest I'm just shooting in the dark with the code.
Any help would be greatly appreciated.
Thanks!
Matt