carry data forward to a new record

[Trevor T]

Hope someone will be able to help me in some way.

I am designing a vehicle log book and maintenance type data base. This
consists of a daily logging of distance traveled as well as re-fueling values
etc etc. Each day is input as a new record on my form. What I want is to
automatically have the previous days " End Mileage" reading being brought
forward to the "Start Mileage" of the next record. Is this possible?

Regards,

 

[Falty]

You could use an unbound combo box which has its rowsource set to a find the
Max value for milage for that particular car, then at some point you would
have to pull that value across into the bound field e.g. StartMilage

The rowsource might look something like

SELECT Max(tblCarLog.EndMilage) AS FROM tblCarLog;

You can open it in the query builder to make any modifications

 

[Klatuu]

Use the Form After Update event to set the Default value of the controls to
the current value of the controls.

Me.txtStartMilage.DefaultValue = Me.txtEndMilage