Searching through a linked SQL database

[cwhite23]

I have been going around in circles on this one. Does anyone have any suggestions on how I can set up a search in VBA on a linked SQL table? I've tried every way I can think of including the rs.index and rs.seek methods, only to find out that they don't work on linked tables! What I'm trying to do is have the user input an order number and have the program search through the database, find the record and all related data, and then export it to a file. I've got everything else working except for the search. Help!!!

 

[BNPMike]

The neat thing about your typical SQL database is it supports SQL. This is a set-at-a-time language so you don't need seek etc. Use instead WHERE.

 

[cwhite23]

What was the old saying? something about not being able to see the forest for the trees?