Hi,
I have a Query in my access db called Tuning. This Query is made up of three tables (tblCUSTOMER, tblPIANO, tblSERVICE_RECORD).
In the tblSERVICE_RECORD table, I have a field called [TuningDate] Now, most of our customers only have one piano which they tune every four months. I want the system to automatically add a new record to the record set, save the old record and maintain tblCUSTOMER and tblPIANO information in tact if I change the date in the [TuningDate] field.
I thought about using the AfterUpdate() even procedure, but I am getting a lots of erros.
Please help!
B.
I have a Query in my access db called Tuning. This Query is made up of three tables (tblCUSTOMER, tblPIANO, tblSERVICE_RECORD).
In the tblSERVICE_RECORD table, I have a field called [TuningDate] Now, most of our customers only have one piano which they tune every four months. I want the system to automatically add a new record to the record set, save the old record and maintain tblCUSTOMER and tblPIANO information in tact if I change the date in the [TuningDate] field.
I thought about using the AfterUpdate() even procedure, but I am getting a lots of erros.
Please help!
B.
