High friends - Here I have a problem which I even find difficult to express in technical terms so I would write in simple words. I'm a newbie- doctor by profession so not very well versed in VBA.
I have made an application to keep the records of pts ( P,BP, WT and medications prescribed)
Each pt is identified by RegistrationID ( TblRegistration)
Each visit is and event recorded as VisitID( TblUniqueVisit)
Medications are prescibed using VisitID and stored in (TblMedicine) with the corresponding VisitID's- so each prescription becomes unique as it has only one VisitID.
Medications are entered in a continous form on each visit- but the problem I face is - in every visit I have to enter almost the same medications as most of the medications do not change over time. Pls suggest How could I copy the previous record of the same patiet ( same registrationID but the last VisitID- this is never the current-1 VisitID as a patientr comes for followup after 1 or 2 months since then the VisitID no as changed by hundreds.when I tried to copy paste by selecting the whole record- the visitID is also copied. Pls also suggest an option where only particular records may be selected as sometimes not all medicines are represcribed.
I have made an application to keep the records of pts ( P,BP, WT and medications prescribed)
Each pt is identified by RegistrationID ( TblRegistration)
Each visit is and event recorded as VisitID( TblUniqueVisit)
Medications are prescibed using VisitID and stored in (TblMedicine) with the corresponding VisitID's- so each prescription becomes unique as it has only one VisitID.
Medications are entered in a continous form on each visit- but the problem I face is - in every visit I have to enter almost the same medications as most of the medications do not change over time. Pls suggest How could I copy the previous record of the same patiet ( same registrationID but the last VisitID- this is never the current-1 VisitID as a patientr comes for followup after 1 or 2 months since then the VisitID no as changed by hundreds.when I tried to copy paste by selecting the whole record- the visitID is also copied. Pls also suggest an option where only particular records may be selected as sometimes not all medicines are represcribed.
