Please help! I have a split form and a combo box that selects CompanyNumber, so when I select it, it filters my form (Private Sub cmbx_CompanyNumber_AfterUpdate()
Me.Filter = "[CompanyNumber] = " & Chr(34) & Me.cmbx_CompanyNumber & Chr(34)
Me.FilterOn = True) according to selection but other fields are never updated. So, when I select another CompanyNumber all other fields IN FIRST record for this CompanyNumber are overwritten by previous ones. If it helps, there are tons of CompanyNumber, so for source for combobox I choose "SELECT DISTINCT CompanyNumber". All fields are bounded properly- when I select records in a datasheet by mouse all fields in form update as they should.