Coding to find record

[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

 

[George Nicholson]

http://support.microsoft.com/default.aspx?scid=kb;en-us;287658
Four ways to move to a record from a Combo Box selection

Even if you aren't using a Combobox, the methods remain the same.

HTH,

 

[Guest]

Thanks George, yeah I have tried it and it works.

Madhuri