Access form to auto submit after entering 1 character

[computersnack]

I have a text field that is 1 character long, on a form in Data Entry mode. I would like it to automatically "hit enter" or similar action so it inserts a new record after the user types in a single character. The purpose of this is for use with multiple barcode scanners, hence the single character. Normally I would type in the character and hit enter to add data to the table, but I would like it to auto-submit. How can this be done? Thank you in advance.

[June7]

Do you mean just want the new record saved? Record is committed to table when form closes, or move to another record, or run code. If those are not sufficient, only way I can imagine to do what you describe is with KeyDown or KeyUp or KeyPress or Change event of textbox.

[computersnack]

Yes, I just want the new record saved after a single character is entered.

[computersnack]

I found my answer on another forum. Using the onChange event, and running this command works for me. DoCmd.GoToRecord , , acNewRec