We use Act 2002 for our office database. When you create a lookup, the lookup will unpredictably jump back to the 1st contact in the lookup. That is, if you look up 20 people in a company and are imputing data on the page of the 5th person in the lookup, you can suddenly find yourself imputing the data on the page of the first. Literally, from one minute to the next, your lookup is back to the first contact.
How can we correct this? Obviously, it's created some problems already.