Combo boxes

E

Ewar

I have a form with a Combo box (Customers) then a Sub form with another
Combo box (Clients). Each customer has its own set of Clients.

Problem how do I get to show only the Clients for the Customers selected.

I can get all the Clients to show or only the Clients for the first record
shown when the Form is opened but then when I select another customer it
does not update the Clients.

It's driving me nuts
Help PLEASE
Eddie
 
E

Ewar

Many thanks for that Allen.

I tried searching everywhere to get help. I have very limited knowledge of
sql etc but at least I have something new to try. The links should be useful
in the future also.
Regards
Eddie
 
Top