Hi Richard,
I have a form that has a field that concatenates three fields together Genus, species and OtherNameValue. As i type in field 1 (Genus) all is well, when I tab to Field 2 to enter (Species) the focus keeps on reverting back to field 1 often mid way through typing in field 2. The same happens in field 3. The concatenated field updates each time it is tabbed. How do I stop the field resetting back to field 1. I feel that the concatenated field is resetting the focus back to field 1?

Any help would be greatly appreciated.

Regards
Stephen

---

Reply from Richard Rost:

If it's happening during the middle of data entry, it sounds to me like you have a TIMER event that's running on that or even another form in your database - or perhaps a KEYPRESS event. Get rid of those. Otherwise the recalc should only happen when you move from field to field. I'd put it in the AfterUpdate event.