ado search field??

[darreldk]

Could anyone direct me to a good tutorial for putting a search field in my ado database?
What i want to do is have a search field on form1 and have it populate a the record on form2 with the results. Any help would be greatly appriated

 

[zemp]

There is an ADO tutorial at

http://www.w3schools.com

and you can see if there are any at

http://www.freeskills.com.

I think that all you need to do is build an SQL statement and include the parameter from form1. This should return the recordset that you are after for form2. Thanks and Good Luck!

zemp

 

[darreldk]

Thank you for the help, I don't suppose you could give me a little example of including parameters in a sql statement?

 

[zemp]

Basically you will be using an SQL statement and then adding a Where clause with you parameter. If your parameter is a string,

Select * From Table1 Where Field1='" & strVariable & "'"

If it is a number, drop the single quotes that surround the variable,

Select * From Table1 Where Field1=" & intVariable

The variable can be a text box as well, Just make sure that you do any data type conversion if they are necessary.

You can take a look at thread709-409184 for an example and discussion of potential problems. Thanks and Good Luck!

zemp