Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing variable to ADO Find method

Status
Not open for further replies.

PeteB2002

Programmer
Aug 10, 2002
20
GB
This should be easy..but it isn't.
HOw can I pass the text entered in asimple text box to the ADO Recordset find command so that it will then search and find the data that matches.
Microsoft only show you how to do it with fixed data hard coded (tsk,tsk) I want this to be dynamic.
 
You have to allocate a string and read the text that has been entered into this string. Then just pass the string....
Greetings,
Rick
 
Here's some code, hope it helps:

rst.Find ("BandName = '" & strRecord & "'")

salu2.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top