Rolling number?? Help

[goju]

Hi

im after rolling number to appear in the top right hand corner of the main form. This number needs to be then transfered into (Data 2) text box automatically.

However at some point i will have to change past records with a new number annually. I still need the (update box) box in the top right hand corner to be updated when inserting new numbers in old records.

the number needs to start at roughly 159631

Any suggestions (Newbie)

I have already used auto numbers in other fields.

 

[WayneRyan]

goju,

"However at some point i will have to change past records with a new number annually"

Why do you need to change past records anually?

Need more information here. What is the number supposed to mean? If you really
need to change it, a form is not the way to do it. You'll only change the records
that the form "sees".

Wayne

 

[goju]

your right sorry,

i just need to update the recors annaully

any one got any ideas

 

[neileg]

Probably an update query run once at the start of the new year. Make sure this number is not a key field. Use DMax() +1 in your update query to find that largest existing number and add 1 to it.