peskywinnets
Registered User.
- Local time
- Today, 08:05
- Joined
- Feb 4, 2014
- Messages
- 576
Tearing my hair out here (I've not worked with forms much, must be missing the point here!)
I'll keep it simple.....let's say I have a table with a field in it called "Barcode"
So I have a form setup with the field Barcode showing (ready to accept input)
What I want to do is take the data entered (it will actually be a scanned barcode), but only use part of the data ...and have extracted data that go to the target field called Barcode, so something like this...
MyBarcode = Mid(Trim(Barcode), 11, 11)
Barcode = MyBarcode
but I can't seem to get access to update the Barcode with MyBarcode.
I'm using the Before Update option & I get this error message....
....any tips please?
I'll keep it simple.....let's say I have a table with a field in it called "Barcode"
So I have a form setup with the field Barcode showing (ready to accept input)
What I want to do is take the data entered (it will actually be a scanned barcode), but only use part of the data ...and have extracted data that go to the target field called Barcode, so something like this...
MyBarcode = Mid(Trim(Barcode), 11, 11)
Barcode = MyBarcode
but I can't seem to get access to update the Barcode with MyBarcode.
I'm using the Before Update option & I get this error message....
....any tips please?