getting record from SQL and place in a textBox in VB 6.0

[rianzares]

hey gus can you please help me.I'm trying to get a record from sql then place in a textbox in vb where emp_no = txtNum.Text

I'm just a beginner


strsql = "Select emp_Lname from emp_data where emp_no = 'txtNum.Text'" & _
" values (" & _
" 'txtLname' = emp_Lname "

PLEASE HELP ME GUYS I NEED THIS URGENT.THANK YOU