ComboBox Limiting Rows Shown

[Steve R.]

My combox can shows 8 rows when entering data, which is fine. Now, that the combobox sucessfully updates when the limit-to-list event occurs, I would like the combox to only show the new value after the limit-to-list event occurs in the combobox and not to show all 8 rows.

I can partially achieve this by: Me.Combo1.ListRows = 1, which leaves one dangling line. Unfortunately Me.Combo1.ListRows = 0
does NOT work. The combobox is reset to 8 rows when the exit event occurs.

Any thoughts?

 

[Steve R.]

Solution, of sorts, found. It finally dawned on me that there was no point in staying in the combobox after accepting the new data. In the Limit to List subroutine, I added a line of code that moves you to the next control requiring data entry after accepting the new data. Consequently, there is no residual drop-down list obscuring the fields below it.