I'm really scratching my head. I have two different databases. Both have a customer form in them. Both have a command button that has the exact same VBA code that runs a macro. The macro's in both databases are exactly the same, (I copied the code and macro's from one to the other). In the first database when you click on the "Find Customer" command button, it pulls first goes to the last name field of the customer and then pulls up the Find and Replace dialog box. When you type a last name in the database, everything works great. If there are several customers with the same last name, no problem, hit the Enter key or click on the Find Next button and the next customer is found instantly. In the second database, after typing in the customers last name it also quickly finds the customer with that last name. When you then hit Enter or click on Find Next, here is where the behavior changes. In the second database, the "Look In:" combo box in the Find and Replace dialog box which said Current Field immediately becomes grayed out and says Current Document, (grayed out). The database takes forever to find the next record that matches the Find criteria. In the lower left corner of the db it says, "Searching, Press CTRL-BREAK to stop. Why are the two behaving differently? How do I get the second to act like the first?
Thanks for your help!