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

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

Post by R2VnaGF » Thu, 07 Jun 2007 09:14:00


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...

Post by John W. Vi » Thu, 07 Jun 2007 09:35:34

On Tue, 5 Jun 2007 17:14:00 -0700, Gegham < XXXX@XXXXX.COM >



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]