VBA sql query problem

Question

Below query is resulting NO rows

lstResults.RowSource = "select EmpId from tblTesting where Empid ='" & Me.txtSearchEmpId.Value & "'"

Where below working fine :

lstResults.RowSource = "select * from tblTesting"

WHere is the fault here? I check the value of '" & Me.txtSearchEmpId.Value & "'" using break point its having the value of "123" (numerical)

My empid is numerical value

Please help

Answer 1

If your EmpId is numerical, you probably want to remove the single-quotes:

lstResults.RowSource = "select EmpId from tblTesting where Empid = " & Me.txtSearchEmpId.Value

How does that work?