On change/update....keep old information

[Gabby Girl]

Currently we have an EquipmentDetail form with a subform "frmTruckAllocation"
that tracks all of our vehicles. In the detail of the subform it shows the
current truck information. Then within that form there is a subform
("fsubTruckHistory") that shows past usage. The "frmTruckAllocation" is not
visible until the user clicks "cmdTruckInfo" button. Main truck allocation
table (tblTruckAllocation) is:

AllocId - PK
EquipmentId - FK
TruckStatus (P-Parked, W-Working, etc...)
DateTruckOut
KMSOut
Driver
AllocRate
DateTruckIn
KMSIn
TruckNotes
Archive

The truck allocation forms are based on two queries: qselTruckAllocation and
qsubTruckHistory which shows only the information where "Archive" = True.

When the user first enters the subform, if the TruckAlloc is a "W" then all
fields are visible except, "DateTruckIn", "KMSIn" and "Archive". When "W" is
changed to "P" the "DateTrucKIn", KMSIn" and "Archive" fields show up. The
reasoning is that when the user reports a truck coming back in and enters the
DateTruckIn, KMSIn and checks the Archive field, then the old information is
supposed to move to History and the current information should now be blank.
That of course if not happening. The old information is being overwritten
with the new information.

Is all this a reasonable way of doing this or are we going about this all
wrong. Should we being using two different tables, one for current
information and one for return information? Should we have other fields like
PrevDriver, PrevDateIn, etc... that get populated with the old information
when "W" is changed to "P" ?

Any guidance or suggestions would be greatly appreciated.

Thanks kindly.