I changed the names of the text boxes to txtRegion, txtDivision, etc....and NOW IT WORKS!!!!!!!! WOW!
The only "glitch" now is that when I select a sales rep's name from the drop down menu in the form (on the combo box), and then press tab, it goes right to the next record (rather than to...