W
Wylie C
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.
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.