strange behavior after adding value to lookup list

[ionic-fire via AccessMonster.com]

Ok, I have been using Dev's code for some time, this code utilizes the On Not
In List event to add value to a combo box's row source (essentially a lookup
list). If user clicks yes, the value is added and focus is moved to the next
tab numbered control on that form. It has worked flawlessly until now.

I have five combo boxes that all have this code in the Not In List event, and
one of them just does not behave correctly. Upon clicking yes in the
confirmation box, the value is added, but then the focus is moved to the next
record, not the next field.

I have tried deleting the combo box and re inserting it and then re-copying
the code to the Not in list event. Same behavior. I even copied the same code
from one of the other working combo boxes and put in this event. Same
behavior. Why is this happening? Any ideas?

Thanks.

 

[Jim Burke in Novi]

I would check the Form's Cycle property. You probably have it set to 'All
Records'. If that's the case, and if the combo box in question is the last
control listed on your form's tab order, then it will move to the next
record. You want the form's Cycle property set to 'Current Record' to prevent
from tabbing to the next record.