Using SQL Query to find information and display in a form, help!!

[padlock]

Hi all,

I hope this is the right place to put this, because it's in regards to Access and an MS SQL server, not using JET anymore.

Well, here's my dilemna. I've had an Access database pretty much dropped in my lap and am responsible for getting it to use the SQL server. I've gotten everything linked up fine, all the info up, etc, and everything appears to be working great.

My issue is I need to use an SQL query to perform searches instead of using the built in find command. The built in command is very slow for anyone remotely accessing (and not too great in the local office, either.) I have figured out how to setup queries that let me bring up information, but I need to have it work like the built in find and just go to that persons info using the form. This I can't seem to do. I have no issue designing an extra form for the search if I have to.

Any help would be greatly appreciated. I'm pulling my hair out over it =D I've tried a ton of different things, and haven't gotten passed just bringing up the information in a table like view!

Thanks again in advance,
-Walter

 

[PHV]

Why not playing with the RecordsetClone, Find or Filter, EOF and Bookmark methods/properties of the ADODB.Recordset and Form objects ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886