A
andrea
I have a form to track Mileage Out and Mileage IN. I need the last Mileage In to automatically fill the next record Mileage Ou
I am using this cod
Private Sub Form_AfterUpdate(
Me.Mileage_Out.DefaultValue = Me.Mileage_I
End Su
When I am entering records this works. When I close the form and reopen, the next record Mileage Out defaults to the 1st entered record. I have tried ordering the form descending but that doesn't work. Should I use a date and time and fill from the most recent date/time? If yes, I need a little help with that. I am new to Access so any help is appreciated
Thank yo
andre
I am using this cod
Private Sub Form_AfterUpdate(
Me.Mileage_Out.DefaultValue = Me.Mileage_I
End Su
When I am entering records this works. When I close the form and reopen, the next record Mileage Out defaults to the 1st entered record. I have tried ordering the form descending but that doesn't work. Should I use a date and time and fill from the most recent date/time? If yes, I need a little help with that. I am new to Access so any help is appreciated
Thank yo
andre