friends, i am making a package in which i want to search in a database.
on my form i have a find button.
i want to use find method of vb.
like
Adodc1.Recordset.Find "Addcity like 'New Delhi'
it works but i want to accept value from user
thru

dim getdata as string
getdata=inputbox("Enter city","search",0)
Adodc1.Recordset.Find "Addcity like 'New Delhi'"

i recieve value in getdata variable.
but i am unable to search value stored in getdata?
how to go abt it?

plz help

micks

: friends, i am making a package in which i want to search in a database.
: on my form i have a find button.
: i want to use find method of vb.
: like
: Adodc1.Recordset.Find "Addcity like 'New Delhi'
: it works but i want to accept value from user
: thru
:
: dim getdata as string
: getdata=inputbox("Enter city","search",0)
: Adodc1.Recordset.Find "Addcity like 'New Delhi'"
:
: i recieve value in getdata variable.
: but i am unable to search value stored in getdata?
: how to go abt it?
:
: plz help
:
: micks
:
:



Use this
Adodc1.Recordset.requery
Adodc1.Recordset.Find "Addcity like '" & trim(getdata) & "'"

: : friends, i am making a package in which i want to search in a database.
: : on my form i have a find button.
: : i want to use find method of vb.
: : like
: : Adodc1.Recordset.Find "Addcity like 'New Delhi'
: : it works but i want to accept value from user
: : thru
: :
: : dim getdata as string
: : getdata=inputbox("Enter city","search",0)
: : Adodc1.Recordset.Find "Addcity like 'New Delhi'"
: :
: : i recieve value in getdata variable.
: : but i am unable to search value stored in getdata?
: : how to go abt it?
: :
: : plz help
: :
: : micks
: :
: :
:
:
:
: Use this
: Adodc1.Recordset.requery
: Adodc1.Recordset.Find "Addcity like '" & trim(getdata) & "'"
:
: thnx it worked
: