FindFirst

  • Thread starter Thread starter Marcello Lenci
  • Start date Start date
M

Marcello Lenci

I want search with FindFirst the first record who contains a substr using
something like:
dim rst as DAO.recordset
set rst as currentdb.openrecordset("List")
aa.caption = rst.findfirst "Name='sm'" //sm is the substr
How can Ido ?
Thanks from now
 
Marcello,

rst.MoveFirst
rst.FindFirst "[Name] LIKE '*sm*'"
If Not rst.NoMatch Then
aa.Caption = rst![Name]
End If

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top