All,
I currently use a subform where it allows the user to issue a vehicle to an individual , with the issue auto populated.
However, I can't think of how to auto populate a return date when the vehicle swaps owner (via query/code).
Ideally I'd like the Return Date to be populated with the new Issue Date.
So any advice to be great appreciated.
Thanks in advance
I currently use a subform where it allows the user to issue a vehicle to an individual , with the issue auto populated.
However, I can't think of how to auto populate a return date when the vehicle swaps owner (via query/code).
ID | Owner | Vechicle Reg | Issue Date | Return Date |
2 | Joe Bloggs | XX10XAB | 01/01/2020 | |
20 | Fred Jones | XX10XAB | 15/01/2020 |
Ideally I'd like the Return Date to be populated with the new Issue Date.
So any advice to be great appreciated.
Thanks in advance