Compare value in previous record

Question

Is it possible on a form to compare a value between the current record and the previous record (not all previous records just the one before)

I am aiming for something like this

when moving through the records if the value in current record field1 = to the value in field1 the previous record then update current record field2 with the value from previous record field2 otherwise update the current record field2 with the value from the previous record field2+1

Answer 1

You said the same thing as in your original question.  I need to know when current field2 should not be changedfor the case where current field1 is not = previous field1.

Think about a scenario where you click on record 1, then click on record 2, then click on record record 1 again and click on record 2 again.  Then explain what should happen to field 2 each time you click on record 2.

Answer 2

What I want to do for example in record 1 is set the value in field2 to 1 then when I hit enter and it moves to the next record it will check to see if the value in field1 current record is the same as the value in field1 the previous record. If it is then set the value in field2 the current record to the same value as field2 the previous record. If the value in field1 the current record is not the same as field1 the previous record then set the value of field 2 current record to field2 previous record +1

Answer 3

Lots of things are possible using some VBA code, but I'm having trouble figuring out how this majes sense.  If current field1 is not = previous field1, then every time you "moving through the records", current field2 is incremented won't do anything except count how many times you move through the record.  Seems like you need additional conditions about when to change current field2 so it doesn't get incremented over and over.