Hi All,
another question....I am pulling my hair out for this one!!!
Currently I have a data entry form that input responses to 15 questions. The questions are in a combo box, and the following fields:
1. JobCode
2. Department
3. IntervieweeName
4. IntervieweeTitle
These fields are the same for all questions 1-15, but changes with different users entering the data.
At the moment, the users have been trained to click on the next record arrow at the bottom, and press Ctrl and ' key to repeat the data from previous record for the above fields. this is time consuming.
I was wondering whether I can create a command button that will on click
1. once question 1 has been entered, go to a new form to enter data: and
2. populate the above fields from the previous first record.
Thanks..i know it's long post...but appreciate any insights!!!
another question....I am pulling my hair out for this one!!!
Currently I have a data entry form that input responses to 15 questions. The questions are in a combo box, and the following fields:
1. JobCode
2. Department
3. IntervieweeName
4. IntervieweeTitle
These fields are the same for all questions 1-15, but changes with different users entering the data.
At the moment, the users have been trained to click on the next record arrow at the bottom, and press Ctrl and ' key to repeat the data from previous record for the above fields. this is time consuming.
I was wondering whether I can create a command button that will on click
1. once question 1 has been entered, go to a new form to enter data: and
2. populate the above fields from the previous first record.
Thanks..i know it's long post...but appreciate any insights!!!