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
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