jamesmills
Technical User
can anyone tell me why this is not working?
i am new to this recordset business!
i am sure i have this correct?
it says there is a synax error in the query expression
Dim currentServerType As String
Dim currentServerNumber As String
Dim serverIP As String
currentServerType = controlPanelType.Value
currentServerNumber = serverNumber.Value
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT serverIP FROM tblServerList WHERE serverType = " & currentServerType & " AND serverName = " & currentServerNumber & ";"
serverIP = rs("serverIP"
rs.Close
i am new to this recordset business!
i am sure i have this correct?
it says there is a synax error in the query expression
Dim currentServerType As String
Dim currentServerNumber As String
Dim serverIP As String
currentServerType = controlPanelType.Value
currentServerNumber = serverNumber.Value
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT serverIP FROM tblServerList WHERE serverType = " & currentServerType & " AND serverName = " & currentServerNumber & ";"
serverIP = rs("serverIP"
rs.Close