Field values

[Billy Garey]

I am new to access and I am learning as I go.
I want to put values in a field that will transfer
automatically to the next record, until I change that
value. Then the new value should appear in the next record
and so on. For example:
Field 1
Record 1: 22
Record 2: 22
Record 3: 22
Record 4: 23 (changed)
Record 5: 23

How can this be done?

 

[Bas Cost Budde]

I am new to access and I am learning as I go.
I want to put values in a field that will transfer
automatically to the next record, until I change that
value. Then the new value should appear in the next record
and so on. For example:
Field 1
Record 1: 22
Record 2: 22
Record 3: 22
Record 4: 23 (changed)
Record 5: 23

How can this be done?

Check the DefaultValue property for a control on a form.