I have this mileage calulation for our different trucks. I want to make my default value for the beginning odometer reading to be equal to the ending odometer reading for the previous day. What do I need to do? Or if this can't be done what kind of validation rule can I have to minimize someone entering the wrong mileage.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using Default Values
- Thread starter cell0042
- Start date
Do you write VBA code? You can use the form's Current event to do a DLookup() for the previous ending odometer reading, and store that value in the beginning odometer reading text box's Default property.
Rick Sprague
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
Rick Sprague
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
- Status
Similar threads
- Locked
- Question