Is your main form a bound form or an unbound form? If it is bound I fail to see the reason for the text boxes that display the current value of the combo box, as the combo box would do that by default. If it is unbound, then the sort of things going on would make more sense. But without seeing the underlying schema (tables and relationships), it is pretty difficult to make more specific suggestions. Would it be possible to post a simplified version with sample data that still demonstrates the problem?
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!