Recordset.Find method - Does this work in axf layers?

[KeithGanzenmuller]

I have a point layer in an axf file, I have a reference to the recordset and I am simply trying to use FIND to locate a particular record. The script keeps throwing an "Object doesn't support this method" error.

Is this correct? Does an axf recordset not support Find?

Thanks,
Keith

[ThaiTruong · Accepted solution]

Yes, RS.Find doesn't work for AXF Feature Layers

[KeithGanzenmuller]

Thanks. I could not find that written anywhere in the help system and there is no differentiation in the OMD for axf and non-axf feature layers. Very frustrating.

[ThaiTruong]

Here is a workaround for you.  I used Riverside.axf\Parcel from ArcPad Samples for this sample code.
The message box shows the address of APN = 225112008

Set objLayer = Application.Map.Layers("Parcel") 
Dim pDS
Set pDS = Application.Map.Layers("Parcel").DataSource
Dim pRS
Set pRS = pDS.Execute("SELECT * FROM PARCEL WHERE APN = 225112008")
If (pRS is Nothing) Then
 MsgBox("No Record Found!")
 Exit Sub
End If
pRS.MoveFirst
Do While Not pRS.EOF
 msgBox(pRS.Fields(3).Name & ": " & pRS.Fields(3).Value & vbnewline & pRS.Fields(5).Name & ": " & pRS.Fields(5).Value)
 pRS.MoveNext
Loop