DoCmd.acGoToRecord Question called from main form to work on 2 Sub forms at same time

[MarkVenes]

OK I am creating an interview form called Allpication8 that has two sub forms on it. The first sub form has only one field on it from one table that table is called INTVQuestions it has two fields the ID filed (auto-number field) and the second field called Question a (text field). I have populated the INTVQuestions table with 20 questions to ask prospective employees. The Second Table is Called INTVAnswers it has 23 fields the first is the ID (auto-number field) the second is the ApplicantsID filed and then fields Answer1 thru Answer20 all (Text fields) to record the answers for each of the applicants according to their ID.



I set this up this way so that the questions can be modified by an administrator as necessary, without having to know how to use Access.

On the main form Called Application8 I have placed the two sub forms so that sub form INTVQuestions shows up at the top and then the INTVAnswer sub form shows up at the bottom. ON the Application8 form (not either of the sub forms) I want to put three buttons, one to go to the next question which would change the question from the INTVQuestions to the next record in the table and at the same time change the INTVAnswers sub form to move it's position to the next field in the same record. The next button would go back one question in an equal manner, and the third would cancel the interview, and delete answers already filled in, then close the form.

Is this possible or am I dreaming too big for my britches? Of course I could always create 20 Question forms and attach it to one table for the answers. But That seems like adding a lot of forms.

As I see it I have two distinct problems, first the INTVQuestion form has only to go to the next record in the table, while the INTVAnswers has to go to the next field in the same record. I am sure that there is way to do it, but I am not sure if anyone has.

Recommendations, Help, Criticism, all are welcome. IN the mean time I am going to start cleaning up my code in all my other forms. Every thing works so far but when the structure makes me look like a beginner, OPPS I am....

Mark.

[June7]

With proper coding, anything is possible. Question is should you?

INTVAnswers table is not normalized structure. This makes it hard to impossible to relate answers to questions.

Here is a recent thread on similar topic - building a survey database: https://www.accessforums.net/access/...ons-29942.html

[MarkVenes]

I solved the problem.

With proper coding, anything is possible. Question is should you?

INTVAnswers table is not normalized structure. This makes it hard to impossible to relate answers to questions.

Here is a recent thread on similar topic - building a survey database: https://www.accessforums.net/access/...ons-29942.html