Hi,
I have an edit form linked to a set of excel tables.
Upon a new entry I want to set one value of a row via a barcode scan. For this I added a barcode scanner doing the following:
OnScan = Set(scanValue, Barcodescanner2.Value)
And the DataCardValue has:
Default = scanValue
For new entries this work.
However if I want to edit this entry it either displays an empty field or uses the "scanValue" from a previous scan.
The goal is to display the value in the excel sheet, however it should be possible to change it with a new scan.
Is this possible and if so how?
Kind regards
Lennsart