How to copy current record's field value to the next row. This is to avoid having to manually entered the same value for each new row until such time as the field is manually updated to a new value. Taking inventory with barcode reader and have a field Location to record where the data was counted; The value will be static until we move to a new location at which time a new value would be entered manually.