Napoleon;

As was stated, if you are using ADO you can use the Find method. To me Find is slow but simple and I prefer to create a new SQL statement to obtain the data I require. This may result in quicker response time if you are using large data sets.

Tom