Create a rolling counter for records 1 - 50 repeating

[oliviar]

Hi Guys,

I am wondering how to put a value into a form field that is a number between 1 - 50.
If the previous record is 1, then this record has to be 2, and if the last one was 50 then this has to be 1.

I am totally stumped and would appreciate some insight.

 

[Sam_D_Ben]

What ?

 

[Joe4]

I think a little more detail is needed.
Can you explain in more detail exactly what you are trying to accomplish?
Is your Form bound or unbound?
A good way to remember a previous value would be to make this counter a bound field.

 

[oliviar]

Its all bound.

I have a category field and a counter field (and then the other details)
I need my records to go like this:

A1 zzzz
A2 zzzz
A3 zzzz
....
A50 zzzz
B1 zzzz
B2 zzzz
B3 zzzz
B4 zzzz

So the counter field goes up to 50, then back to 1. It rolls through these numbers.

 

[Joe4]

Is this a continuous form?
Is it an entry form?
Do you want this value to be pre-populated as you enter new data?
Do you use an Autonumber field in the table that the Form is bound too (this will be helpful in determining what the last record entered was)?

 

[strive4peace]

if you want to be able to start over again, then you need to know WHEN records were created. Add this field to your table:

dtmAdd, date/time. defaultValue = Now()

well this is the first step ... but before I tell you the rest, I must ask why?