[RESOLVED] [2005] Creating SQL commands

[stimbo]

I'm just trying to get the hang of SQL and .NET. I was wondering can I use the field, from a textbox for example, to help create my SQL command?

This wont work so obviously there's a problem with doing it this way:

' Set the SELECT statement for the Command object
            cmdUserSelect.CommandText = "SELECT ShapeID, " _
                & "Shape, Colour " _
                & "FROM Features WHERE Shape = " & Me.shape.Text

Am I close or miles away?