D
Database User
Hi this is quite a complicated question - i hope i can explain myself clearly!
Basically i have a customer form with a subform and there are 16 records
that i paste into the subform and all the user has to do it is to tick Action
Successful when each of the 16 actions has been completed. All the actions
are ticked on unfinished and with Tina's help i made it that after update
i.e. when action Successful is ticked then automatically unfinished gets
unticked. Now i have a further question.
I want that when the 6th action is successful then automatically action 13's
unfinished tick box is unticked but action sucessful is NOT ticked.
when 8th action successful ticked then 15th action unticked unfinished
when 12th action successful ticked then 16th action unticked unfinised
action ID of 6, 8 12 is CA
action ID of 13, 15, 16 is DA
then
6 and 13 both have and id AW
8 and 15 both have an id BW
12 and 16 both have ID DW
Is there a way to do this - Please help!
Basically i have a customer form with a subform and there are 16 records
that i paste into the subform and all the user has to do it is to tick Action
Successful when each of the 16 actions has been completed. All the actions
are ticked on unfinished and with Tina's help i made it that after update
i.e. when action Successful is ticked then automatically unfinished gets
unticked. Now i have a further question.
I want that when the 6th action is successful then automatically action 13's
unfinished tick box is unticked but action sucessful is NOT ticked.
when 8th action successful ticked then 15th action unticked unfinished
when 12th action successful ticked then 16th action unticked unfinised
action ID of 6, 8 12 is CA
action ID of 13, 15, 16 is DA
then
6 and 13 both have and id AW
8 and 15 both have an id BW
12 and 16 both have ID DW
Is there a way to do this - Please help!