Combo boxes

message from Ewar on 9 May 2004
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
 
Allen Browne replied to Ewar on 9 May 2004
http://www.mvps.org/access/forms/frm0028.htm
 
Ewar replied to Allen Browne on 10 May 2004
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

"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:409e1fcb$0$16595$5a62ac22@freenews.iinet.net.au...
 

Archived message: Combo boxes (Microsoft Access)