Can i scan barcode then move to next record (1 Viewer)

Hi all

I have a Table with two fields on Order No and Date Received
I created a form in table view that i use

Every order number is bar coded, what i want to do is scan a order in then it put the date and time in automatically and move to a new line for the next order to be scanned in .

It scans the order but i cant get it to move to new record after scan.I did try and do a macro in the after update event to go to new record but sadly it stay in the same field and ad the next order on at end of previous order.

Thanks in advance for any help on the subject :banghead:

put the date and time in automatically and move

Click to expand...

to do this, put

Now()

in the default value property

to move to the next record, make this date/time control enabled=no and locked=yes. And in the form other properties set the Cycle property to all records

Thanks! I just discovered the value of the Cycle property.

Thanks CJ_London
Appreciate your help got every thing working

For some reason my enter-key behavior was set to ad new line in field that is why after every thing it did not move to next record .I set the property to to default behavior on the enter key behavior now it works like a charm .
Thanks again

Keep in mind you need to tell Access and the Barcode scanner your intentions.
In the Access's option sheet.



The scanner can be programed with it's own options. Here is just a few.
HTH