I can't figure out what's wrong with this SQL statement. I need to show on texbox Name&Surname...
Code:
Private Sub Form_Current()
Dim strSQL As String
Dim rs As DAO.Recordset
strSQL = "SELECT Old.EmpD, Emp.Name, Emp.Surname, Old.Place FROM Emp INNER JOIN Old ON Emp.EmpID = Old.EmpID WHERE (((Emp.Name) Is Not Null) AND ((Old.Place)=[Forms]![Structures]![SiteID]) AND ((Old.Function)="2") AND ((Old.UpTo) Is Null));"
Set rs = CurrentDb.OpenRecordset(strSQL)
Text22.Value = rs
End Sub
Last edited: