tab to next field on afterupdate

  • Thread starter Thread starter Joseph Atie
  • Start date Start date
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.
 
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.
Click to expand...

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.
 
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.
Click to expand...

Thanks John, i wasnt aware of the autotab feature. thats all i needed.
 
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.
 
Back
Top