Automatically creating new form after data entry?

[stell]

Hello, all.

I have a problem that's been driving me crazy all week. Hopefully someone can point me in the right direction.

So I made a form to enter data into a table. The form only consists of 2 fields. This form is being used by employees using a scanner. What I want to happen is right when they scan in the information into the second field, a new form to automatically show up.

I'm trying to avoid having the employee have to put down the scanner and manually create a new form every time. I want them to be able to scan in data at a fast pace.

I tried the "gotorecord" macro but it gave me an error saying 'you may be at the last record' or something like that.

Any advice would be greatly appreciated!

 

[CJ_London]

have you considered using a continuous form? sometimes called a multiple item form