Display contents of a table on a form - MS Access
Posted on 2016-10-24
I have an Access database wherein, through a Form with numerous textboxes, “Employee A” enters records that get saved to a table (Employee A’s credentials are also saved to the table to be able to identify who entered the records). In the table, I have a Batch Number field. Let’s say on a given day, in one sitting ‘Employee A’ enters a bunch of records and then finalizes that particular batch by either pressing a “completed” button or by exiting the database.
Eventually, “Employee B” will have to do something with the information contained in the batch records. What (s)he will have to do is independent of anything I’m asking the database to handle.
All I’m looking for the database to do (unless someone has a better idea, which on here seems to always be the case) is to have a form for “Employee B’s” use to display records in a batch or batches (that Employee A entered) and to have a checkbox (or some similar boolean functionality) next to each record that allows “Employee B” to mark or “check-off” the records that (s)he has taken care of so far. Employee B’s credentials as well as the checkbox information would be the only fields in the original record that could be updated by Employee B. Employee B cannot tamper with any other fields in the record. Employee B’s only function is to mark or “check-off” the records (originally entered by Employee A) that (s)he has taken care of.
So, the question is:
How do I display the contents of a table in a list format that allows a user to “check-off” any unchecked records and when (s)he does, have the table updated with the “check-off” value and Employee B’s credentials (let’s say UserID and name).
I mentioned ‘display the contents of a table’ directly above because I’m trying to keep my question as short and simple as possible. Ideally on the form for Employee B’s use, I’d like to have a combobox or the like that will list the “open” batches (i.e. batches where all records have not been checked-off yet…meaning Employee B has not addressed all batch records yet). Employee B would then select the batch (s)he wants to work with from the list and that batch’s contents would be displayed on the form (as opposed to the ENTIRE table’s contents).