Use barcode to trigger event on Form

[JoeyGaspard]

I have created an access form that uses a barcode scanner to enter data for employee supplies, they can scan up to 5 supplies per employee. What I would like to do is after they have scanned all they are issuing to the employee, to be able to scan a barcode that emulates clicking the Add Record button. I am trying to do this process with no keyboard/mouse input. Everything works perfectly if they scan 5 items to every employee because the scanner tabs after the scan, but if they only scan 2 items, I need them to be able to scan a barcode to add that record in preparation for the next employee. I hope this makes sense, and thank you in advance!

 

[Candyman8019]

Then where I have
'do something here to add record

You'll put your code in there to copy the range to the bottom of your table, wherever that may be.

 

[Candyman8019]

Ah, MS Access...I see now...I'm not familiar with the syntax of MS Access; however the logic should be similar.

 

[welshgasman]

If your database was properly normalised, you would not need that, as each item would already be a record?
So your incorrect structure is causing you this issue.

 

[JoeyGaspard]

If your database was properly normalised, you would not need that, as each item would already be a record?
So your incorrect structure is causing you this issue.

I guess I dont understand what you mean? Are yu saying that every field in the form would be written to the table as its own record?

 

[welshgasman]

Every item in supplies would be written as a separate record.
What happens when they are allowed 10 items?, then you have to change your form?

GUI would likely be a mainform for the employee and a subform for their supplies.

 

[JoeyGaspard]

This has been resolved.

 

[Fluff]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[JoeyGaspard]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

This is the code used to resolve the problem.

Private Sub Item2_AfterUpdate()
With Me
If Item2.Value = 9999 Then
DoCmd.GoToRecord , , acNewRec
Me.EmployeeID.SetFocus
End If
End With

End Sub

 

[welshgasman]

So what if you have two barcodes or more, and the 3rd, 4th or 5th have the 999 value?
You have to repeat that code in each of those?

 

[JoeyGaspard]

So what if you have two barcodes or more, and the 3rd, 4th or 5th have the 999 value?
You have to repeat that code in each of those?

It is repeated for each field