Storing Record Number in Field so it updates automatically

[BWG3]

I am currently storing the "record number" of a form to a field in a table. Is there any way to have this field of the next row of the table increment up by one from the previous record number of the row above it. Right now, it keeps defaulting to 1, so I am getting multiple record numbers when a new row is created with data from the form.

Ex.

Record #
1
2
3
4

Let's say I deleted row 4 and I go back to my form and created a new row with data, it now does this...

Record #
1
2
3
1

Thanks in advance.

Brandon

 

[boblarson]

What "Record Number" are you talking about? Not the thing showing in the navigation area below, I hope as that has nothing to do with records on a permanent basis. It is only a Relative thing which is based on the current recordset that is open.

 

[BWG3]

I see. Thank you for that clarification.