Populate controls in next record Continuous Form

[libraccess]

I have a continuous form with the controls
MStartDate (first day of month)
MEndDate (last day of month)
RAV_Meter (number)
This is used to record the meter reading and is used elsewhere to compare performance against other data on a monthly basis
what I thought would be really helpful to save time and errors would be if on moving to the next record if the MEndDate is entered, the new record MStartDate would be populated with the next day (1st day of month) with the RAV_Meter populated with the previous meter reading.
If moving from the RAV_Meter and the MEndDate is blank the focus could be set to the MEndDate in the next record. I have been playing around for ages but with no joy. Maybe someone has done something like this? thanks

[June7]

Customarily, only the current/ending meter reading and date would be recorded. Query would retrieve values from the previous record to use in calculation for the difference. Review http://allenbrowne.com/subquery-01.html#AnotherRecord

Don't understand why RAV_Meter would be populated with previous meter reading. Where do you put the current/ending meter reading?

[ItsMe]

Never tried it before but... you could put some code in the MEndDate double click event. You could start with a vbYesNo to confirm adding a record and then execute something like


dim endDate as date
dim strMeter as string

endDate = me.MEndDate
strMeter = Me.RAV_Meter

DoCmd.GoToRecord , , acNewRec

MStartDate = endDate + 1
Me.RAV_Meter = strMeter