matching data (barcodes) in a datasheet view and show extra info automatically

[dennisb82]

With my current frmMutations I can't notice when a product is sorted at a wrong store. In the attached access-file I want to be able to scan the barcode of a Custstr (see tblStore) and then automatically populate the Customer en Storenr of the FrmMutations for the next productbarcodes, until I scan the next Custstr.



For example: The barcodes of the product all begin with a number. The Custstr begins with letters. So I begin scanning a Custstr (Example IR1001) then a barcode of a product and automatically it sets the Customer (IR) an Storenr (1001) in the fields next to the barcode. After all product of this store are scanned, I scan the next Custstr (IR1002). And so on. Some customers have 2 and some 3 letters before the storenumber.

On the frmMutations we already have some coding done for barcode at the AfterUpdate event. Maybe I can detect letters in this even and than store the customer/storenr and put them in the fields when I scan a productbarcodes until I scan a new Custst? With Do While and letters recognizing?

Is this possible?

[June7]

Use code in the Custstr textbox AfterUpdate event to set its Default Value property.

[dennisb82]

So I can somehow read this Custstr from a barcode and use the customer and storenr as default values for the next productbarcodes? How exactly?

[June7]

As I said, use the control's AfterUpdate event to set its DefaultValue, at least that is recommended solution for normal data entry. I am not sure scanning will trigger the AfterUpdate. Perhaps if the scanner is set to feed carriage return it would work.

If the field is text data type:

Me.controlname.DefaultValue = "'" & Me.controlname & "'"

If the field is number data type, don't use the apostrophes, if it is a date/time type use #.

[dennisb82]

Got it! thanks.