In a subform, a field gets populated (on double-click with a macro that calls some vba code,) by getting a number from a table. Repeat this action for each row in the form, and it continues to get the next sequential number. Before 2007 this worked. In 2007, this works as long as you do not use the scroll bar, after using the scroll bar it re-orders after getting each new number, it actually causes the number to be put in a different field because the re-ordering happens after asking it to get the new number. I cannot find out where or why the re-ordering is happening.