Create a new form as needed

[John]

I have a database I created to track contact with bariatric patients who had
the surgery done at our hospital. One of the forms I created allows the nurse
to fill in answers to questions when they call the patient post-op.
Originally there was only one contact so the form worked well. Now the staff
would like to use the same form howerver make it capapble to be used over and
over again to show many contacts for the patient without loosing the original
data.
My first thought was to create a giant form with 7 copies of the same form
all in a row so they could fill in for seven contacts. But what if they
contacted the patient 30 times?
Is there a way to place a button (or something similar) on the form so when
the nurse wants to create a new version of the form they can just click
something and it automatically creates a new blank form to use without
copying over the old one? This way there can be an unlimited number of
forms/contacts to be used.

[Daniel Pineault]

This has very little, to say nothing, to do with your form, but rather with
your table structure.

What you need to do is have a patient table and then a post-op table which
is linked to the patient table by the patient ID. Then you can have a
1-to-many relationship enabling you to have as many entries in the post-op
table as required.

Your post-op table should contain, amongst other things, the patient id,
post-op consult date (this way you can sort the entries in an efficient
manner).

In this manner, you would either create a sub-form to house the post-op data
in your main patient form or create a stand alone post-op form.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

[John]

Daniel
Thanks for the reply. Maybe I need to be more specific. I already have a
post-op table which is where the original form was created from. The
form/table works great for the original contact. However, when the nurse now
makes the second contact using the exact same questions as the first form;
and want to see the old data that was input on the first contact to make sure
the patient is following through. She wants to add another copy of the same
form to fill in for the second contact. They would like to see the forms in
order of contact so they see all of the data. The contacts may happen daily,
weekly or just once.
I guess I could create a giant form with 10 sub forms all containing the
same fields. If they only make one contact then the rest would be blank if
they need more then they would only be limited to a certain number of
contacts. Is there a way to add a subform (not sure what to call it) with the
exact same fields as needed for a person who does not know Access and needs
everything done simple.

[John W. Vinson]

On Wed, 6 Jan 2010 11:46:04 -0800, John <Jo...@discussions.microsoft.com>
wrote:

>Thanks for the reply. Maybe I need to be more specific. I already have a
>post-op table which is where the original form was created from. The
>form/table works great for the original contact. However, when the nurse now
>makes the second contact using the exact same questions as the first form;
>and want to see the old data that was input on the first contact to make sure
>the patient is following through. She wants to add another copy of the same
>form to fill in for the second contact. They would like to see the forms in
>order of contact so they see all of the data. The contacts may happen daily,
>weekly or just once.
>I guess I could create a giant form with 10 sub forms all containing the
>same fields. If they only make one contact then the rest would be blank if
>they need more then they would only be limited to a certain number of
>contacts. Is there a way to add a subform (not sure what to call it) with the
>exact same fields as needed for a person who does not know Access and needs
>everything done simple.

You're making an easy job much harder.

You can see multiple records - the past history of visits - using a Continuous
Subform. The mainform would be based on the patient demographics; you could
have a Subform (with its default view set to Continuous Forms) for the visit
data. This will let the user see data from multiple visits all on screen at
the same time, and allow new visit data to be added.
--

John W. Vinson [MVP]