It sounds like you have a good start and as you have seen it is not difficult to implement this type of modification with Modifier and VBA. If you are able to add your check box to the Employee Maintenance card then you will not need to access the SQL data directly to determine the status of the check box. All you need to do is add your check box to VBA (Tools-Customize-Add Fields to VB and click on the check box), then use the following code (all on one line).
If EmployeeMaintenance.(your checkbox).Value = True Then MsgBox ("This employee has requested that some of their data be suppressed. Please review employee notes.")
Replace (your checkbox) in the code with the name of your checkbox (no parentheses).
This should get the customization working on your pc. However, since I don't know how familiar you are with GP setup I would be remiss to not give you a word of caution before jumping in with both feet. If this is the first time Modifier and VBA is being used in your GP system there are a few details that you need to know and it is important to first be familiar with your GP environment. So before continuing on with your first coding adventure please consider these points;
I applaud your resourcefulness and wish you much success in streamlining your GP processes. Please let me know how it turns out.
If you've found this thread useful, dive deeper into User Group community content by role