Hi All.
Apologies if this query appears in an existing thread. Have looked but cannot find an answer as don't really know what to search under!
I have a form with a field called "Handed Over" with a tick box. When the job (record) is "handed over", I have been going back through every job and ticking the box for that record. It is done month by month and there are normally 80 to 100 jobs completed so there are quite a few records to go back into and tick.
Is there a way to automatically make all records ticked when required? I have tried a macro with "setvalue" but it doesn't seem to work.
Many Thanks in advance.
Apologies if this query appears in an existing thread. Have looked but cannot find an answer as don't really know what to search under!
I have a form with a field called "Handed Over" with a tick box. When the job (record) is "handed over", I have been going back through every job and ticking the box for that record. It is done month by month and there are normally 80 to 100 jobs completed so there are quite a few records to go back into and tick.
Is there a way to automatically make all records ticked when required? I have tried a macro with "setvalue" but it doesn't seem to work.
Many Thanks in advance.