summing in a form..

In my form i have Beginning Mileage, Ending Mileage, Total Daily Mileage. As
of now I have to enter Beginning Mileage, my Ending Mileage is =Nz([AR],0)+Nz
([LA],0)+Nz([TX],0)+Nz([MS],0)+Nz([OK],0)+Nz([Other])+[Beginning Mileage].
my Total Daily Mileage is =Nz([AR],0)+Nz([LA],0)+Nz([TX],0)+Nz([MS],0)+Nz([OK]
,0)+Nz([Other]). Is there a way that i can make my Beginning Mileage carry
over from the previous record (so i wouldnt have to manually enter it)?
Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1

.

Relevant Pages

  • Re: Insert field from previous record
    ... Providing Customers A Resource For Help With Access, Excel And Word ... Private Sub Ending_Mileage_AfterUpdate ... new record for the next month on a vehicle, the Beginning Mileage will ... automatically populate with the most recent ending mileage entered? ...
    (microsoft.public.access.forms)
  • Re: Insert field from previous record
    ... Doug Steele, Microsoft Access MVP ... Private Sub Ending_Mileage_AfterUpdate ... new record for the next month on a vehicle, the Beginning Mileage will ... automatically populate with the most recent ending mileage entered? ...
    (microsoft.public.access.forms)
  • Re: Code/Function to Look at Previous Entry to Validate Data
    ... we can assume that the end mileage must be greater than the ... each successive ending mileage must be> ... time the formula checks for the maximum end mileage for the vehicle number ... The entry in C2 is a number ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Trip Mileage Calculation
    ... I have a starting mileage, ending mileage and trip mileage field. ... One way is to use a script that sets the field Starting Mileage based on the Ending Mileage of the last trip. ...
    (comp.databases.filemaker)
  • Re: Insert field from previous record
    ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... mileage fields within the form or table fields. ... automatically populate with the most recent ending mileage entered? ...
    (microsoft.public.access.forms)