Sequential Numbering-- question on Stephen Lebans' RowNumber

[KFox]

I found this information on another user's question on sequential numbering,
but wondering how I can save the generated number in a table? Right now the
control source is set to: =RowNum([Form])

Here's the link to Stephen's code:

<http://www.lebans.com/rownumber.htm>

Thanks!
Kellie

 

[Michel Walsh]

You can append the data into a temporary table, but which will have an
autonumber field in addition to the other fields you have data. That
autonumber field will get the values 1, 2, 3, ... as records are appended to
it, even if you do it in just one batch.


Hoping it may help,
Vanderghast, Access MVP