I have a datasheet which stores a list of valid programs included in this list is the option to flag a program as invalid via a checkbox, each record has its own individual ref# this is generated automatically.
What I need to do is have some form of code which will run on the on click procedure of the checkbox and will duplicate the current record, setting the new records valid box as valid [false] true whilst leaving the old record as invalid [true].
I understand what I want to do but the difficulty is finding some code which will effectivly select the current row and copy and paste it on the end of the list.
Anyone who can assist will have my gratitude.
What I need to do is have some form of code which will run on the on click procedure of the checkbox and will duplicate the current record, setting the new records valid box as valid [false] true whilst leaving the old record as invalid [true].
I understand what I want to do but the difficulty is finding some code which will effectivly select the current row and copy and paste it on the end of the list.
Anyone who can assist will have my gratitude.
