Microsoft, Access, 2007, VBA - simple record search

Here's another one basically out of the book.  I really think I have a dud book (Access 2007 Bible).  I'm getting the error message "No value given for one or more required parameters."  What could be simpler than just doing an open operation on a uniquer value on one field.  Here's my code.

  Dim rs As ADODB.Recordset
  Dim SQLStmt As String
 
  Set rs = New ADODB.Recordset
  SQLStmt = "SELECT * FROM ToolingTable WHERE ToolingNum = " & Me!ToolingNum
  rs.Open SQLStmt, CurrentProject.Connection, adOpenDynamic, adLockOptimistic

The debugger tells me
SQLStmt = "SELECT * FROM ToolingTable WHERE ToolingNum = TRDI-1020-001"
which looks exactly correct to me.  I'm definitely overlooking something quite basic.  Thanks for the help.

Helen