Hoping for some advice here:

I am currently using Visual Basic 6 with Microsoft Access to enter tool information into a tooling database.

In this front-end application I have a form for ordering new tools with a couple of text boxes and a drop down combo.

What I need to be able to do is search the existing records in a table called Tool_Order for an exact match to the data entered in to the form so that I can warn the user if they attempt to order the same tool again.

The Tool_Order table from access is in a datagrid filled from an adodc connection and in the code I have used ADO to update the information stored in the Access tables.

How can I search the datagrid fields for matches to the text box inputs? Is there another way with the method I am using (ADO)?

Any help greatly appreciated..