Autopopulate Access Form Field From Previous Record Value

[mustaqalifj]

I'm using MS Access 2010. I have a form which has following fields: TransactionDate, StartKm, EndKm, Oilchange, NextOilChange.
NextOilChange is a calculated field (EndKm-OilChange).
What I have been trying to do unsuccessfully is once I enter a number(Km)in Oilchange field it automatically appear in the nextday's record and so on. Giving a running total of km since last oil change, until its time for next oil change. After new oil change new km is manually entered again. Want the record to persist even when Access is shut down.Many many thanks in advance...help.

[NeoPa]

I think you first need to understand/appreciate that the data is stored, not in sequence, but in a table. Records can be shown in sequence when they have data within that can be used for sorting.

Your explanation doesn't mention this which leads me to believe your design doesn't really incorporate it. Certainly what you've explained is not adequate to take information out as, apparently, it's not in there to take out.

Details are critical. Different approaches can work in different circumstances and the approaches can be very different. Without a clearer explanation of what you're working with it's hard to know which suits better.

I suspect that you really need to calculate the total by scanning through the data and finding the maximum stored value. How would that be filtered though. Your explanation leaves that unexplained.

[mustaqalifj]

Apologizes, I was trying to be concise... I do have a table named DailyKm and a form for entering the Data called DailyKm. Fields are as aforementioned initially. Hope that provides more clarity? Thanking you for your help...

[NeoPa]

Hi again.

Your question was clear and concise. What is missing is information that would be in there if the design were as it should be. I assume that it's missing not because you forgot to tell us, but because you didn't realise it was required in the first place for good design.

However, we still only know what you tell us so my post was trying to prompt you to think. I suggest you read it again and consider what information would be needed in order to give you meaningful results. I see nothing there to indicate which vehicle the data refers to, and nothing in your question that explains you use only one, or even that you walk a lot and drink oil when you're thirsty.

In short, what I said before, we need all relevant information. If we don't know about something then it's very hard for us to help you with it.