Hi ALL!

I would like to have the first field on a form auto-increment with each new recorded added to the forms table. I know of the NEWID() way, but this involves modifing the table. Does any have any suggestions on how I can accomplish this useing just code?

I considered useing the last Record number in the table and incrementing it by 1 each time, but No matter where I place my simple code, it gives errors and\or totally flips out the "add" function to the form.

I was useing something like this:

Local lnCount
Select MyTable *** the table to be added to
lnCount = Count + 1
Thisform.firstfield.value = lnCount

Please help!

TIA,
DAN