Limiting 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...

 

[hansford cornett]

-----Original Message-----
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...
.
You may want to use REQUERY to get the process to requery.

You may also break it down into districts, states, citys
to get around the restriction...

please respond back to the newsgroup so all may see.