I have a form. The form has several fields. I would like to enter (with a barcode reader) a value in field "Field2", then duplicate that record after that value is entered by the barcode reader. I have it working but it creates some extra blank records? How can I do this or what am I doing wrong? It is set on lost focus.
Thanks...
Private Sub Command10_Click()
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend
[Field2] = ""
Me.[Field2].SetFocus
End Sub
Thanks...
Private Sub Command10_Click()
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend
[Field2] = ""
Me.[Field2].SetFocus
End Sub