Re: Native MS Access 97 Searches from an Access Form

2003-06-12 Thread Daniel Kasak
Sean Meegan wrote: I'm running Access 97 as a front end to a MySQL ODBC linked table. Everything is working fine with the exception of long searches from within Access. In the past we would be able to go to any one of the fields from within the Form, and then do a Ctrl + F to find a record by

RE: Native MS Access 97 Searches from an Access Form

2003-06-12 Thread Uttam
do not use Ctrl-F, it will retrieve all the records and then try to find the specific record. Instead change the form record source property dynamically with SQL statement having appropriate where clause, result will within eye blink. regds, -Original Message- From: Sean Meegan