how to create copy of form for same record ID

[OccamsShaver]

Hello-
I have created an Access database for a research study. I created a form which allows the user to enter patient questionnaire data. Some patients will have completed the same sets of questionnaires on multiple occasions. I am wondering how I can essentially duplicate the questions in the same form (with different variable names, of course) without doing it all manually.
I know nothing about VBA and did the form through the GUI (as I have the few other times I have designed similar databases in the past).

Thank you for any help on this.

OccamsShaver

 

[ranman256]

You don't need vba.
run an append query to copy the source record (using the ID)
and append to the target table.
get the new ID (the largest) and open it.

 

[OccamsShaver]

You don't need vba.
run an append query to copy the source record (using the ID)
and append to the target table.
get the new ID (the largest) and open it.

Thank you, Ranman. I'm not sure that I understood that. I am wanting to set this up so that assistants who are entering data can easily enter a second set of the questionnaires if there are some for a given patient, without having to leave the form.

 

[xenou]

The form has different questions for different patients?

 

[OccamsShaver]

The form has different questions for different patients?

No. There is a set of questionnaires which patients complete before and after an intervention. A small subset of patients will have gone through the intervention several times and that is what I am trying to address in creating the database.

 

[xenou]

Okay, I wasn't sure what you meant by a second set of the questionnaire. I suppose you mean just copy the last one (use the same answers). Ranman's answer sounds straightforward to me. If you don't need to keep a history of changes, then you could also just use the last one as is and just update anything that has changed.

 

[OccamsShaver]

Okay, I wasn't sure what you meant by a second set of the questionnaire. I suppose you mean just copy the last one (use the same answers). Ranman's answer sounds straightforward to me. If you don't need to keep a history of changes, then you could also just use the last one as is and just update anything that has changed.

I apologize that I have not been very clear in explaining the scenario. For patients that go through this treatment multiple times, the answers will not be duplicates each time. For example, if John completes the treatment, he will have data for pre-treatment and post-treatment questionnaires. If Mary went through treatment twice, she will have data for pre-treatment and post-treatment #1 and pre-treatment and post-treatment #2. The questionnaires are the same for each round of treatment, but the responses will not be the same. The vast majority of patients have completed treatment only once, but some have completed treatment several times.
Thanks again for your thoughts and help.

 

[xenou]

Sorry, I'm not really sure what your setup is here. If the questions are the same and you don't want to pull up the previous answers, then how is this different from just having the patient take the questionnaire again?