Enter data only for records in a subform that are 'checked'
Posted on 2006-11-16
I have an Access 2000 database with a table for employees (tblEmployees) which includes a large text field (txtNotes) for adding comments to each record. We have occasions where we need to add the same note to many of the employee records all at once. Not necessarily ALL of the records, but most of them.
What I’m envisioning is a form where the user enters the text. A subform shows a list of all employees, and the user can check or uncheck these employees as appropriate. Clicking “Save” on the form would insert the given text into the txtNotes fields of the employee records that were checked.
Anyone ever done something like this? How can you do this kind of a “check box” approach?
Thanks in advance,