SQL select statement

strSQL="SELECT * FROM TABLE_NAME WHERE FIELD_NAME=VALUE"
objRS.Open strSQL, objConn