PrimaryKey as reference to key field?? like dao

[kiwiCoder]

is it possible to use "Primary Key" as a reference to the field to be searched as in dao. IE
My ADO code
tTable.Open sTable, cnxnCroppak, adOpenDynamic, adLockOptimistic
tTable.Fields(0).Properties("OPtimize") = True
tTable.Find "[Primary Key] = " & lTableKey

Original DAO code
Set tTable = gdbCropPak.OpenRecordset(sTable, dbOpenTable)
tTable.Index = "PrimaryKey"

tTable.Seek "=", lTableKey
I have tried
tTable.Find "tTable.Fields(0).value = " & lTableKey
but that doesnt work either.
Any help appreciated

 

[donutman]

Wrong forum, but you might try tTable.find "PrimaryKeyFieldName = " & lTableKey
That would assume that the field is type int. If it were varchar, they you would have to place single quotes around lTableKey.
-Karl