Visual Basic Record Set

In Visual Basic while assigning the value for a variable,I’m unable to pass the variable to the recordset Select (Sequel) statement.Shall I know the exact syntax and method to assign the variable instead of value.
Example: temp = 1070
data1.recordset=(shape{select * from tble where field=temp})