Record # shown in the navigational buttons

[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

 

[boblarson]

Michael:

The "record number" that is shown in the navigation buttons really have no
meaning whatsoever outside of the current session that you have. Access does
not store the records in any meaningful order, but they can be displayed in a
consistent order IF you assign a way to do it. You can set an autonumber
primary key but autonumbers can actually skip around as they only really
guarantee a unique number.

The best way is to include a date/time stamp (date and time in ONE field) at
the time your record is created. That way you can have the form display
based on a query with the sort on the date/time created.


--
Bob Larson
Access World Forums Super Moderator

Tutorials at http://www.btabdevelopment.com

__________________________________