I have a main form, attached to which is a subform.
When a new record is created in the subform that record has it's [Data checked by] column blank.
The [Data checked by] field is locked intentionally.
I want to be able to update it in code which is easy enough to do, but only when the "Checked" check-box is set to true and the "Sign" button is then pressed.
For each record in the subform I want there to be a "Checked" check-box, so the user can select whichever records and have them signed when they click the button.
I don't want the "Checked" check-box to be a part of the data structure that supports the subform, it isn't necessary and would be a bit of a waste of space (it would be a small amount for each individual record, but over 15000 records, well, you get the picture).
Does anyone know any means by which I could do this?
Thankyou in advance for your response.
Andy
When a new record is created in the subform that record has it's [Data checked by] column blank.
The [Data checked by] field is locked intentionally.
I want to be able to update it in code which is easy enough to do, but only when the "Checked" check-box is set to true and the "Sign" button is then pressed.
For each record in the subform I want there to be a "Checked" check-box, so the user can select whichever records and have them signed when they click the button.
I don't want the "Checked" check-box to be a part of the data structure that supports the subform, it isn't necessary and would be a bit of a waste of space (it would be a small amount for each individual record, but over 15000 records, well, you get the picture).
Does anyone know any means by which I could do this?
Thankyou in advance for your response.
Andy
