I'm using Access2000.  I need to be able to work with a subset of records in
my main database of public records from the register of deeds.  One of the
indices is by Book/Page.  I need to be able to determine what records might
already exist in the database with an existing book/page when a new record
is to be added in my add routine. The existing DB name is GES.

I want to be able to create a small recordset in program code with a select
statement that uses the book/page that is on an incoming transaction.  In
the example below, I've hard coded the book page for illustrative purposes.

Here is what I'm trying to do, could someone point the way so that I can
flesh this out more?

Dim myBook As String, myPage As String, rstGESBkPg As Recordset

myBook = "6917"
myPage = "647"
Set db = CurrentDb()
Set rstGESBkPg = New Recordset
rstGESBkPg.Open "Select * From GES where ges.fcdtbook =" & myBook & " and
ges.fcdtpage=" & myPage & "", _
   CurrentProject.Connection, adOpenKeyset, adLockOptimistic

---------------
The code above gives me a "Data type mismatch in the criteria expression"
The book/page fields in the GES database are text
Don't I need to open the GES db and specify the book/page Index to be used
for the select statement?