best way to insert new record

[hnunez4399]

What would be the best way in a form to have the form automatically go to nwe reocrd once data is entered.

So if the field is 12 characters and you enter that is tabs right down to that field.

This field is bases on a query running in the back round as a look up table.
Thanks,

 

[Rolliee]

Why not have a command button named "New Record" with the appropriate code under it? The wiz can help you do this.

Rollie E

 

[hnunez4399]

I do not want them to click a button. They are using a scanner for inputing the data and then the cursor should move to the new record..
let me know if there is a way for this