Help with carrying over values

[htjr]

I am new to Access. I now own Access 2010. I am trying to make a form to keep track of fuel mileage for my semi truck. It's for IFTA. I made a table in access that works ok. The two fields of concern are Odometer begin, and Odometer End. I was wondering if there is a way to carry over the value in Odometer End, to have it automatically entered in Odometer Begin field of the next record so I don't have to type it in every time I start a new record? Example; Record 1: Date: 1/1/2012, Odometer Begin: 1,084,241, Odometer End: 1,084,441. Record 2: Date 1/2/2012, Odmeter Begin: 1,084,441. I have to type the ending mileage from the previous record into the begining mileage of the present record everytime.

[Robeen]

If you use a Data Entry Form to enter your data, you can put VBA code into your Form Load event or behind a 'New Record' Button that searches for the highest Odometer Reading in the Table and puts it into the Odometer Begin Text Box on the Form and then sets the focus on the Odometer End Text Box on the Form to let you enter the new reading.

[htjr]

Thank you for replying so quickly Robeen. I have no idea at all, what-so-ever on using Visual Basic. I do have a data entry form with a new record button in place.

[burgerpj]

Here is a solution.... enjoy! It makes the last value of ODO_END the default value for ODO_BEGIN. See the Word Document attached with detailed steps.

[htjr]

Thank you both so much for the fast help. Everything works great. Thank you again!!