Form..new record..max value in tbl

[Guest]

I have a form that opens in the open new record view. On the form there is a
bound control, RecNum (from the Statistics tbl) which is the primary key. How
do I test the table to see if this is a new record and if so, update the
first record number to 1 then each time the form opens I want to get the
maximum value from the RecNum field in the table and add one to the maximum
number. I wanted to do this instead of using an autonumber field.

Thank you.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com) is a small sample database
called "AutonumberProblem.mdb" which illustrates how to use the DMax domain
aggregate function to find this value.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L