Repost: Desperately need some guidance please...

[Gabby Girl]

Hello,

I recently posted a question about how to go about tracking pickup truck
usage but got no response, so I'll try and trim it down and hopefully someone
can point me in the right direction.

Basically what I need to do is track the ins and outs of our pickup trucks
with kms in and out. The trucks are are all listed in a main table called
tblEquipmentMaster. Currently I have a subform (called frmTruckAllocations),
within that subform is another subform (called frmTruckHistory) which are
both in my main form "frmEquipmentMaster. frmTruckAllocations is linked to
frmEquipmentMaster via EquipmentId fields and frmTruckHistory is linked to
frmTruckAllocations via AllocId (all three tables contain EquipmentId).
Fields in frmTruckAllocation are:

I have no trouble getting the information that I require into the tables,
its how to show them in form view. What I'd like to do is this:

When cmdTruckInfo is clicked in frmEquipmentMaster, the subform pops up with
Current user (date out and kms) with continuous subform showing past usage
(Driver, Date Out/In and KMSOut/In). If the truck is not being used at the
time I need the subform to show Current Status (P-Parked), with no driver
info or date out/kms out, and the continuous subform still showing past
usage.

I'm obviously going about this wrong (as it's not working). I've tried
adding PrevDriver, etc.. fields, append/delete queiries and still not able to
achieve what I want (not sure what I want is even feasible or normal). So
if someone could please point me in the right direction or give me some
guidance I would be truly greatful.

Thanks Kindly

 

[Gabby Girl]

No worries, I think I figured out a solution.