Solved How to scan a barcode from a parent form and update the child/subform in MS access

[nector]

Instead of the users lookup for the correct product code/barcode from the subform I want the users to simply scan the barcode from the parent form from the control called productcode and once that is done then the after update event fires and update the subform.

Option Compare Database
Option Explicit
Private Sub Text9_AfterUpdate()
Forms!frmCustomerInvoice![sfrmLineDetails Subform]!ProductCode.Form.Requery
DoCmd.GoToRecord , , acNewRec
End Sub

For example the productcode or barcode = 4100525 once scanned from the parent form it should create a new line in the child form

 

[arnelgp]

here test your form.
see the code on the "barcode" (main form) Before and After Update event.

 

[nector]

here test your form.
see the code on the "barcode" (main form) Before and After Update event.

Thank you so much, that is exactly what I was looking for, many thanks also go to other respondents

 

[Mark_]

Only issue I've ever had with bar code readers is some don't include a return or CR/LF when scanning. Just something to keep in mind and warn end users during product setup for their scanner.