T
Terry
I need to supply the next record number to a data input form
I tried Autonumber and the DMax() which caused problems because I have to
Archive deleted records and both of the above would cause duplicate record
numbers.
I tried using a macro to get the last number of my table nothing works.
I searched this Helpgroup for an answer which advised me to use Autonumber
and DMax() all to no avail.
Can anyone help?
Terry
I tried Autonumber and the DMax() which caused problems because I have to
Archive deleted records and both of the above would cause duplicate record
numbers.
I tried using a macro to get the last number of my table nothing works.
I searched this Helpgroup for an answer which advised me to use Autonumber
and DMax() all to no avail.
Can anyone help?
Terry