Copying values from a previous record to a current form

[David T. Allison]

I have created a form that updates a table with bound edit box controls. The
nature of our data is that for a given field in the table there may be a
long sequence of repeat values from record-to-record, so, my form needs to
populate the current bound edit box witha "default" value derrived from the
field value from the previous record. In pseudocode I imagine something
like:

MyForm.MyEditBox = MyTable.Field1[CurrentRecord-1]

If "CurrentRecord" was a pointer to the current record in the table being
edited by the form, then the results of the expression right of the "="
should yield the previous record "Field1" value. I'm new to Access and VBA
so I'm sure the syntax is not correct- perhaps you guys can help me out.

 

[Joe]

David,

This may help: http://support.microsoft.com/kb/q136127/

Joe