While entering data in a subdatasheet, I would like the user to be able to press the "Enter" key and have the certain values from the previous record appear in the new record. For instance, there are four fields in a row and the first three usually won't change these are "Depth", "Length", and "NightsSet". Once the user enter's data in the fourth field "PoundsCaught", I would like Access to move to the new record, copy the values from Depth, Length, and NightsSet into the new record, so then all the user has to do is enter PoundsCaught. I also have a "Day" field that I would like to autoincrement to the next day when "Enter" is pressed.
The problem is, I don't know where to even start this process. Any suggestions?