Hi,
Basically, I need my database to update a table/s when I close a form. It is a car rental and sale company and I need, when a form for either a lease or sale is completed, to change the field on the car table for the car to unavailable (ie it's on lease or has been sold), on the staff table I have a sales/lease performance figure and I need that to be increased by one for each lease and sale. Finally, this would make a query I need to do a bit easier, for the form to update the member/customer record with the date for that lease or sale.
Regards,
Jeff
Basically, I need my database to update a table/s when I close a form. It is a car rental and sale company and I need, when a form for either a lease or sale is completed, to change the field on the car table for the car to unavailable (ie it's on lease or has been sold), on the staff table I have a sales/lease performance figure and I need that to be increased by one for each lease and sale. Finally, this would make a query I need to do a bit easier, for the form to update the member/customer record with the date for that lease or sale.
Regards,
Jeff
