Combo box does not show all the records returned by its query

  • Thread starter Thread starter Guest
  • Start date Start date
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.)
 
Please post the RowSource property of the combo box. Also, is there any code
attached to other field's AfterUpdate event, or the form's OnCurrent event
which might reassign the RowSource property?

Sprinks
 
Back
Top