Coding to find record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form with subforms based on queries and tables and I am
trying to add a find button to find record matching the
Dim txtlname as string
Dim rstLname as recordset

txtlname=inputbox ("Select lastname of customer")

How do I proceed with saying

rstlname=("select * from table where lastname='" & txtlname & ")
and how do I point the form record to go to the record containing lastname
as txtlname ?

Thanks
Madhuri
 
Back
Top