ADODB.recordset.find gives a compile error expected function or variable

I have a recordset created and held in a public variable while bouncing through some userforms.
One of the options I have is an uprevision of the data and I want to use recordset.find to prefill some of the fields in a userform for adding records.
The error I get is as described highlighting the ".find"

Public Function DBlatest(PartStr As String) As Variant
objRecordset.MoveLast
DBlatest = objRecordset.Find("PartNo = '" & PartStr & "'", , adSearchBackward, objRecordset.RecordCount)
'objRecordset.FindLast
Stop
End Function

I am hoping this is just a syntax error because I do not want to have to loop through the recordset as an array.

I don't think the Find method returns anything - it should just find the next matching record or set EOF if nothing is found. You can then query the recordset to retrieve the data you want.

See here for an example: https://learn.microsoft.com/en-us/sq...l-server-ver16

WBD