NewTexican
Technical User
I have a subform that is a continous form. Plan number from mainform & employee number on subform & company number on subform is a unique combination. Employees can work for more that one company. I have a query set up in rowsource of combo that lets user select which company goes with employee.
Me.Combo23.RowSource = "select [company name], [company numeric] from [person-company q] where [person numeric]= " _
& Me.Person_Numeric
the combination refered to above is stored in a different table.
works great except when scrolling on main form. The company name that was selected for the employee doesn't show up in the last combobox of the subform. If I click the box (not the arrow selector, just the box) it populates with the previously selected company name (if I click the arrow selector I'm given the correct choices). I want it to show the company name without having to click on it. All the other combos on the subform are displaying the company name correctly, it's just the last one. Isn't this wierd?
Me.Combo23.RowSource = "select [company name], [company numeric] from [person-company q] where [person numeric]= " _
& Me.Person_Numeric
the combination refered to above is stored in a different table.
works great except when scrolling on main form. The company name that was selected for the employee doesn't show up in the last combobox of the subform. If I click the box (not the arrow selector, just the box) it populates with the previously selected company name (if I click the arrow selector I'm given the correct choices). I want it to show the company name without having to click on it. All the other combos on the subform are displaying the company name correctly, it's just the last one. Isn't this wierd?