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!
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!