Me.DO_NOT_DISPLAY_SSN.Value = False
Can someone explain what would happen if I change the value to true? Thanks in advance for your help!
boblarson
06-14-2007, 07:12 AM
It depends on what the rest of it all is doing or looking for. But, it looks to me like if you change it to True then it is going to set a checkbox to true which then tells some other code not to display the social security number.
Thanks, what I'm trying to accomplish is if someone selects the checkbox and doesn't want their SSN displayed, to have an associated report not display their SSN. I have included another line of code, I am hoping someone can tell me what it does:
strSQL = strSQL & ReturnFieldArgument("@DoNotDisplaySSN", Me.DO_NOT_DISPLAY_SSN.Value, False, True)
I believe I have found the line of code I need to modify for the associated report:
strUpdate = "UPDATE [NO REASON LETTER REPORT TABLE] "
If (.Fields("DO NOT DISPLAY SSN").Value) Then
strSet = "SET [SORT FIELD1] = '" & RemoveSingleQuotes(strSort1) & "', " & _
"[SORT FIELD2] = '" & RemoveSingleQuotes(strSort2) & "', " & _
"[EMPLOYEE SSN] = ' ' "