Regarding Neil's question about searching and Richard's answer.  Richard, great answer, but here's a further question.  I like to have a search work where it brings you to the specific record you're looking for, but with all of the other records still present, so you can still scroll to other records when you're done with the one you wanted.  Your solution, I believe, would leave you with the form only showing the particular records which met the search criteria.  Then you'd have to have another button to reload all records or something when you were done with that record.  Can you work this so that the code merely brings you to the proper record without changing the underlying record source?

---

Reply from Richard Rost:

Yes, you certainly could. Just open the form without custom SQL and then you could use a Docmd.FindRecord command to find a specific record using the field name and criteria. I believe it was covered in Access 307.