Continuous form record counter

[Sly600rr]

Hey guys, quick question,
I have a continous form that I'm trying to number like;
1
2
3 (ect..)

I have came up with a way that works, but I'm sure that I'm over complicating it.
I have a [recordcounter] field with a default value of 1, and a text box in the footer with the control source =sum[recordcounter] then some vba that pulls that sum and makes it the value of my [recordnumber] field.

It works.. kinda but it's slow and sometimes doesn't update right. please someone help me find a better solution to do this!

thank you!

 

[Sly600rr]

I know its been talked about a lot, but i can't seem to find the solution i'm looking for,

I dont know why I can't just do something like this. it makes since to me but i can't make it work.

Tried putting this in the form even load

Public Sub Form_Load()
Dim Counter As Integer
counter = 0
End Sub

And this in the before update of my txtrecordnumber field..

Public Sub txtrecordnumber_Click()
counter = counter + 1
Me.txtrecordnumber = counter
End Sub

They were set to private, and I tried to make them public thinking that the txtrecordnumber couldn't pull the Counter variable from the form load event, but that didn't work either..

it seemed to make since to me.. but am i being retarded? it wont count!!