Validation Autofill Query???

[swk003]

I have a validation form that a user will scan 175 records into a textbox using a barcode scanner. I am attempting to reduce the number of keystrokes a user has to press when updating this form, i.e. i dont want them to have to press enter after each record!! To do this i hope to be able to use an autofill function which updates the record and then clears the textbox for the next record to be scanned!! Can anyone help at all?

thanks

swk003

 

[ProgramError]

Hi
In a macro put...

Action

gotorecord

Action arguments

RECORD new

and call this after the barcode has scanned

Program Error
Programmers do it one finger at a time!

 

[swk003]

Can you suggest a suitable event method to call the macro from. I am already using before update() and after update()methods within the form!!

thanks

swk003

 

[ZmrAbdulla]

This simple code will take you to the new record. But you may need to validate the record as they are filled with acceptable data.

DoCmd.GoToRecord , , acNewRec

You can use this code OnExit of the last field.

[tt]If data accetable then
DoCmd.GoToRecord , , acNewRec
Else
No new record
End If[/tt]

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.

 

[swk003]

Great this seems to work fine. Thanks

swk003