according to your file, this is the line: If strDBNTUserName <> "" and Trim(rs("M_PMRECEIVE")) = "1" and strPMStatus = "1" Then
if you look further up in the file for the sql statement for the recordset rs, starting on line 167, you are not returning values for the field M_PMRECEIVE. Check the instructions for the PM mod and make sure you added everything correctly to the pop_profile file.