Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
strSQL="SELECT * FROM Bud2005 INNER JOIN Security ON Bud2005.UserID=Security.UserID WHERESecurity.User = '"& Session("UserID")&"'
Hi,make sure Session("UserID") is not empty at this moment.You can use Response.Write Session("UserID") to print it somewhere on the page.