Z
Zortact
I am using Access 2003 to build a database that stores information for every
intubation performed on patients. I use a subform in a main form to capture
the information for each intubation that is performed. For example, on the
main form I have patient A's demographics. I then enter the first set of
intubation information for patient A in the subform. If the intubation was
unsuccessful then I need to perform a 2nd attempt on patient A, so I click
the navigational button on the subform to move to the 2nd record and so on.
I move to a new record on the main form for patient B and repeat the above
steps.
Is it possible to store the record # that is displayed by the navigational
button on the subform, to my table? I need to report how many 1st, attempts,
2nd attempts, 3rd attempts etc. are done on each patient.
I have some Access programming experience and would appreciate any help out
there, or a better suggestions that what I have created.
Thanks, Michael
intubation performed on patients. I use a subform in a main form to capture
the information for each intubation that is performed. For example, on the
main form I have patient A's demographics. I then enter the first set of
intubation information for patient A in the subform. If the intubation was
unsuccessful then I need to perform a 2nd attempt on patient A, so I click
the navigational button on the subform to move to the 2nd record and so on.
I move to a new record on the main form for patient B and repeat the above
steps.
Is it possible to store the record # that is displayed by the navigational
button on the subform, to my table? I need to report how many 1st, attempts,
2nd attempts, 3rd attempts etc. are done on each patient.
I have some Access programming experience and would appreciate any help out
there, or a better suggestions that what I have created.
Thanks, Michael