I have upsized my Datasbase in Access 2003 to a SQL2000 server. (I have notupsized the application due to the size and complexity of the forms, so all the tables have been converted to link tables).
When doing a find (ctrl+F) the responce is exceptionally slow. looking at previous threads, they all seem to agree that ctrl+F should not be used.
I have created a query that will return the data i want to find using the *&[Search]&* on the relavent fields in the query.
I want to apply this query to a form button so they click 'Search' they enter in what to search for and the form goes to that record.
However, if I try to execute the query from te button the results are returned in the form of a data sheet.
How can i display the resulting record(s) in the form and how can i have a 'Find Next'?
When doing a find (ctrl+F) the responce is exceptionally slow. looking at previous threads, they all seem to agree that ctrl+F should not be used.
I have created a query that will return the data i want to find using the *&[Search]&* on the relavent fields in the query.
I want to apply this query to a form button so they click 'Search' they enter in what to search for and the form goes to that record.
However, if I try to execute the query from te button the results are returned in the form of a data sheet.
How can i display the resulting record(s) in the form and how can i have a 'Find Next'?
