Hi thank you in advance for anyone helping with my problem.
I have a user form with a combo box that lists truck 1, truck 2 etc up to truck 10
I have three text boxes with start hours, end hours and total hours which all works fine in the user form at updating my table but,
What I cant work out is when I for example pick Truck 1 from the combo list, the finish hours of Truck 1 from the previous entry automatically appears in the start hours as the finish hours is always the start hours of the next entry.
I hope I am explaining properly. I would like this to happen with all machine numbers.
COMBOBOX TEXT BOX
01/01/2018 TRUCK 1 START HRS:123 FINISH HRS:125 TOTAL HRS:2
02/01/2018 TRUCK 1 START HRS:125 FINISH HRS: TOTAL HRS:
I have a user form with a combo box that lists truck 1, truck 2 etc up to truck 10
I have three text boxes with start hours, end hours and total hours which all works fine in the user form at updating my table but,
What I cant work out is when I for example pick Truck 1 from the combo list, the finish hours of Truck 1 from the previous entry automatically appears in the start hours as the finish hours is always the start hours of the next entry.
I hope I am explaining properly. I would like this to happen with all machine numbers.
COMBOBOX TEXT BOX
01/01/2018 TRUCK 1 START HRS:123 FINISH HRS:125 TOTAL HRS:2
02/01/2018 TRUCK 1 START HRS:125 FINISH HRS: TOTAL HRS:
