Hello all,
I have a database that tracks mileage and fuel for our fleet of trucks. We have a paper trip report that gets entered into an access database.
On the form "frm_TripReports" there is an "OdometerStart" and an "OdometerEnd". Each trip report is specific to each Vehicle. Vehicle is defined by "LicensePlate".
Is there a way to start each entry with the "OdometerStart" auto filled with the most recent record's "OdometerEnd"? "LicensePlate" specific.
I have a database that tracks mileage and fuel for our fleet of trucks. We have a paper trip report that gets entered into an access database.
On the form "frm_TripReports" there is an "OdometerStart" and an "OdometerEnd". Each trip report is specific to each Vehicle. Vehicle is defined by "LicensePlate".
Is there a way to start each entry with the "OdometerStart" auto filled with the most recent record's "OdometerEnd"? "LicensePlate" specific.