Passing Data From Text Box Into A Database Query

[DAPOOLE]

How can I go about passing data from a forms text box into a SQL query?

Basically I want the [userdefined] entry in the below SQL to be data entered from a text box:

strSQL = "SELECT * FROM [userdefined] ;"

Thanks in advance.

 

[namliam]

"SELECT * FROM [" & [userdefined] & "];"

make sure to include either Me.[userdefined] if the code is in the form or use Forms("Yourformname")![userdefined]

 

[DCrake]

strSQL = "Select * From " & Me.UserDefined

David

 

[DAPOOLE]

Brilliant. Thank you.