Hello all,

I have encountered a weird problem with my listbox. (I can not use a grid, because this is an upgrade of existing software that doesn't budget changing the control used.) Now here's the setup of my listbox:
The RowsourceType = 6 - Fields
The controlsource is a variable that evaluates a SQL expression that reads from a table.

The problem occurs when I programmatically add or remove an item from the listbox (over 1000 items), the LISTCOUNT property displays the value of all the records in the table. Say I add 1000 items to the list programmatically it displays a LISTCOUNT of 1000 items, but when I add 1 more item it display a LISTCOUNT of the total number of records in the table.

Has anyone encountered this problem before? If so, any ideas on how to remedy the situation?

Thank you,
-Diran