G
Guest
I've a combo box on a subform which returns a list of customers from which
one can be chosen. It's based on a query which, when run separately,
successfully produces a full list of customers (a few hundred of them,
nowhere near 64k). But when run within the combo box, the list is much
shorter. And not a consistent number of rows, either - just not all of them.
Incidentally, a similar number of records is returned whether the list is
sorted or not (when sorted then it returns the first records in the sorted
set, not a sorted selection of records from the set).
Any ideas why, or how to correct this behaviour?
(This is happening on a client/server system in which I am the only user
during development.)
one can be chosen. It's based on a query which, when run separately,
successfully produces a full list of customers (a few hundred of them,
nowhere near 64k). But when run within the combo box, the list is much
shorter. And not a consistent number of rows, either - just not all of them.
Incidentally, a similar number of records is returned whether the list is
sorted or not (when sorted then it returns the first records in the sorted
set, not a sorted selection of records from the set).
Any ideas why, or how to correct this behaviour?
(This is happening on a client/server system in which I am the only user
during development.)