I have created a table driven email notification system which sends emails using outlook to employees depending on if a boolean field (blnEmail) in the email notification table is set to TRUE. I'm wanting to create a tabbed panel with a control that displays all records in the email notification table so that managers can check/uncheck the boolean field (blnEmail) depending on whether an employee should receive email notifications. I'm not sure what approach to take. I'm not very familiar with combo boxes, list boxes or subforms. Any suggestions would be appreciated.
-
-
If you want the user to be able to edit checkboxes then you will need to use a subform to display the records. I would suggest that you set the subform to open as a datasheet. This should make everything relatively easy. -
I have to assume that you want to add a tab to a pre-existing form. Otherwise I don't see any reason for a tabbed panel. You may be over complicating the task, but let's assume for a moment that your design approach and my assumption are both correct.
Start out by making a new form. The data for the form should come from your email notification table. All you need is a single checkbox on the form, bound to the boolean flag blnEmail, and the Employee ID number.
Then, go back to your original Employee maintenance form and add a Tab for "Email Notification." Drag your new form onto that tab. That will make your new (email notification) form a subform of the main (employee maintenance) form.
In the properties of the subform object you will need to put the Employee identifier from the main form in the Master property and the Employee identifier from the Email Notification table in the Child property. That way, when you choose Employee X on the main form, the subform contains the matching data from the Email Notifications table.
Hope that helps,
JimComment
Comment