Hi all... please help me with this code... i hv retrieved the id of the employee from the login n stored it as a lable in my form- logid but now with respect to that i want to get the employee name... please help very urgent!!
Dim rs As adodb.Recordset Dim getname As String getname = "SELECT E_name FROM Employee_Details WHERE E_ID ='" & logid.Caption & "'" rs.Open getname, CN logname.Caption = rs.Fields(0)
the error msg shown is "object variable or with block variable not set."
please help its very urgent!