When I am trying to add a record programmatically...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I am trying to add a record programmatically using barcode scanner, the
new record sometimes appears instead of last row, not in the new row in MS
Access 2002.
I have tried to add a record by means of eider Append Query or Data Entry
form. Result is the same.
Please, tell me is there any reason for such an abnormal behavior, and how
can I resolve the problem.
Thank you. With regards Gegham.
 
When I am trying to add a record programmatically using barcode scanner, the
new record sometimes appears instead of last row, not in the new row in MS
Access 2002.
I have tried to add a record by means of eider Append Query or Data Entry
form. Result is the same.
Please, tell me is there any reason for such an abnormal behavior, and how
can I resolve the problem.
Thank you. With regards Gegham.
Click to expand...

Please post your code.

You may need to add a line

DoCmd.GoToRecord acDataForm, Me.Name, acNewRecord

to explicitly go to the new record prior to scanning the barcode.

John W. Vinson [MVP]
 
Back
Top