Copy record (History) from one Admission to the other

[swali]

I have a History table which is connected to the Admission table and the Admission table is connected to the Patient Information table. You can have multiple Admissions for one patient. I want to be able to copy the record in the History table to the next admission. Since the History of the Patient doesn't change much from one admission to the other. I want each Admission ID to have a different History ID.
Hope that makes sense .
Thank you.

[ChipR]

Sure, that makes sense. You're going to have to ask a question if we're to help, rather than stating what you want.

[swali]

How can I copy records from the history form, because some of the history information stays the same, and show them in the next Admission? But records should not be overwritten. Each record need to have its own HistoyID and AdmissionID.
Thank you.

[ChipR]

Do you want to copy records from the history form to another form, or to the same form, or a subform? Or from a table?
What form are you entering the records on? Is it bound to a table?
Do you know any VBA?
Would you like to give us any other information that might make it possible to help you?

[missinglinq]

I assume you have an admission date field, as well as admission ID, history ID, and history fields. You must also have a field that uniquely identifies each patient..

What are the names of each of these fields, and what are the datatype (Text or Number) of the admission and history IDs?

What is the name of the table holding these fields?

Welcome to Bytes!

Linq ;0)>

[swali]

First time writing on a forum so didn't know what or how to ask
I do know some VB
The frmHistory is a Subform and is linked by an Account_No.
Account_No is an ID in the frmAdmission, its an Alphanumeric key and has a foreign key from the frmPatientInfo.
tblPatient: PatientID (Numeric)
tblAdmission: AdmissionID (Alphanumeric) , PatientID(Forei gnKey)
tblHistory: HistoryID(AutoN umber) , AdmissionID(For eignKey)
I have it to where when you click on the History button it opens the History form and is filtered to show only the record related to AdmissionID
You can have multiple Admission for one Patient
Ex: A patient comes in and this is their 2nd Admission How can I display the information from the 1st AdmissionHistor y to show up in the 2nd AdmissionHistor y? So the person entering the information can save some time.
I am using Access 2007
Thanks again
Hope I was clear this time
Please let me know if there is anything else you guys need to know

[NeoPa]

Are you still requiring help on this Swali?

[swali]

@NeoPa
Thank you for replying to my post
I did figure out how to copy records from one form to the other by saving it as Public intCopyField As String
and then on the cmd button click on the first form
intCopyField = Me.Text0
and then on the load event on the second form
Me.Text1 = intCopyField
if there is a better way please let me know
Thanks Again
and Happy New Year!

[swali]

Actually I started working on a different project and thought that they both had similar issues and just went back to this one and read my old post and realized its not the same.
And since it was something that was "desirable" by the user and not "mandatory" I finished the project without it.
I would love to implement this feature if you can help me.
Please let me know if you need any more information other than what I posted 4 week ago.
Thank you.

[NeoPa]

When I get some time (hopefully this evening) I'll read through what you've said again and see if I can make sense of it. If I can I'll see what I can suggest. Otherwise I'll explain what I need you to communicate more clearly and we can proceed from there.