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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DAO Recordset Issue 1
Using Findfirst recordset to search memo field type 11
Keep getting .NoMatch! 5
Finding value in Form Load event 3
FindFirst 1
compile error 5
Error after change BE from Access to SQL 7
Syntax error (missing operator) in expression 2

Back
Top