Hi everyone.
I am trying to write some vba code to auto fill a cell's value based on the value of the cell in the previous record (In a datasheet form)
i.e. if the value in record one was '1' and the down-arrow key was pressed then the value '2' should be entered into the new\next record
I...