How to get record from SQL and place in a textbox on VB 6.0

How to get record from SQL and place in a textbox on VB 6.0

rianzaresrianzares Posts: 1Questions: 0Answers: 0
edited February 2012 in General
please help me guys I need this urgent...Thank you!
I'm trying to get a record from sql where emp_no = txtNum.Text then place in a textbox.
Can You please correct ty

strsql = "Select emp_Lname from emp_data where emp_no = 'txtNum.Text'" & _
" values (" & _
"'" & txtLname.Text & "')"
This discussion has been closed.