Limiting the contents of combo box

[ardy]

Trying to resolve the 65K limitation of the combo box..

We have a DB environment with Agents(table) who have many
clients(table), and each client has many customers(table).

the customer table is well beyond 65k records. In order
to lookup customers i am trying to use a form/subform to
limit the contents of the combo box.

For particular reasons, the user need to select a client
from the main form, and then the sub-form will display all
customers associated to the client's agent.

The form/sub form works, but only for the very first
selection of the client. All associated customers are
displayed thru the subforms combo box. however, if a
different client is selected from the main forms combo box,
the subform displays the very first set of customers
associated to the first client's selection!!!

how do I force the subform to re-load the combo box
contents accordingly?

Thanks...

 

[John Vinson]

however, if a
different client is selected from the main forms combo box,
the subform displays the very first set of customers
associated to the first client's selection!!!

Requery the subform in the first combo box's afterupdate event.

You can actually skip the subform (unless you need the subform for
some other reason) - a combo box can be based on a Query referencing
another combo box; you also need to requery in this case.