I want to list only specific records belonging to a certain group without having to enter permissions for each user in the advanced security area. I tried to use this in ListonLoad Event but does not seem to work getting data type mismatch error.
Here is my code:
str = "select fldgroup from users where UserId='" & Session("UserID") & "'"
Set rsTemp = server.CreateObject("ADODB.Recordset")
rsTemp.open str, dbConnection
Session("fldgroup")= rsTemp("fldgroup")
strSQL = AddWhere(strSQL, "[fldgroup]='" & session("fldgroup") & "'")
