I've noticed that my forms behave differently while running locally vs. running on the sharepoint.
One of the tricks I use is to have several combo boxes all referring to the same control source. That way a user can find a record by more than one method. i.e.
[ID] [First] [Last]
Then I just make the first column 0 width to hide the [ID] and sort by [First] so I can scroll by first name to find the record.
When I do this locally, all combo-boxes update in synch.
When I do this on the sharepoint, only one combobox shoes the value.
Is there a way to do this where all of the combo boxes stay in synch?