Form..new record..max value in tbl

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top