Use variable in select SQL field (1 Viewer)

Hi all, is it possible to use variable instead of field name after where in select sql ??

pSQL = "select * from tbl_Data WHERE Type1 = '" & Me.Text0.Value & "' "


in the code i want to use variable instead of Type1 and I wrote it but it didn't work :

var = me.text2

pSQL = "select * from tbl_Data WHERE " & var & " = '" & Me.Text0.Value & "' "

Should work. Use this to see how the SQL is coming out:

http://www.baldyweb.com/ImmediateWindow.htm

You may need to add brackets if the field name has spaces or symbols.