trying to use rg.find as shown below:

checkit = RTrim(rs.fields("ERCOT_UNIT_ID")) & "_" & RTrim(rs.fields _
("timestamp")) & "_" & RTrim(rs.fields("SETTLEMENT")) & "_" &
nameofbook
spcs = 150 - Len(checkit)
checkit = checkit & "" & Space(spcs)
rg.movefirst
rg.Find = "PRIMARY_KEY=" & checkit

I know the error is on the rg.Find line and is a result of the variable
checkit. Checkit is a string and Primary_Key is in the database as a char of
150 characters, hence the addition of blank spaces to checkit. How do I get
around this error? It seems you cannot use variables with the Find method?
Thank you.

Brent