CheckBox for Subform that allow user to select record

[Ihussein]

Hello,
The idea is that I want to add a check box to my datasheet which it's placed in a sub form, to allow user select only one or multiple records which it's help me a lot for validation, submission, deletion,& approving of the records.
Regards

 

[sneuberg]

So, add the Yes/No field to the table, add the check box to the form, and buttons on the main form validation, submission, deletion,& approving and add the code to the click event to do these things.

You might consider the Data Sheet view for the subform. With that you can at least select multiple records for deletion without adding any code.

 

[CJ_London]

another option is to build a disconnected ado recordset. see this link

https://support.microsoft.com/en-us/kb/184397

 

[Ihussein]

Easy way is to go ahead with yes/no field.
Thanks