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