tab to next field on afterupdate

J

Joseph Atie

I have a sub form that is a datasheet.

This sheet logs the barcodes for a transaction.

The input for this sheet is a barcode scanner.

I need the sheet to automaticly drop down to the next line after the scanner
has entered the code so that the next code can be scanned. I dont want the
operator to have to scan then tab down to the next field.

help please.
 
J

John W. Vinson

I have a sub form that is a datasheet.

This sheet logs the barcodes for a transaction.

The input for this sheet is a barcode scanner.

I need the sheet to automaticly drop down to the next line after the scanner
has entered the code so that the next code can be scanned. I dont want the
operator to have to scan then tab down to the next field.

help please.

I'd use a Continuous Form rather than a datasheet, since you have more
control.

I presume that the barcode is a fixed-length Text field? If so, be sure that
the table definition has the size of the field equal to the barcode length,
and set the textbox's Tab Order property to the last on the form; its Auto Tab
property to Yes; and the form's Cycle property to Next Record.
 
J

Joseph Atie

John W. Vinson said:
I'd use a Continuous Form rather than a datasheet, since you have more
control.

I presume that the barcode is a fixed-length Text field? If so, be sure that
the table definition has the size of the field equal to the barcode length,
and set the textbox's Tab Order property to the last on the form; its Auto Tab
property to Yes; and the form's Cycle property to Next Record.

Thanks John, i wasnt aware of the autotab feature. thats all i needed.
 
P

PG.Isacsson

Also most handheld scanners can be programmed to have a carriage return
(enter) or even a TAB command as soon as you release the button.... figured
that out after A LOT of headache trying to program the access to do the
thinking.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top