cascading combo boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sandyL - 30 Oct 2007 10:30 GMT

I have 2 sets of combo boxes on my form where box 2 is set to only show the
values that match with what was picked in box 1. My problem is the first set
works great but the second set on box 2 will only show the first value no
matter what you pick. I have looked to see if I can find any differances in
the programming and they appear the same. What could I be missing. Thanks
in advance

Reply to this Message

Paolo - 30 Oct 2007 12:11 GMT

Hi Sandy,

Do you requery combo2 after you change the recordsource according to the
value you choose in the first combo?
Could you post the code you use to filter the second combo after you choose
a value in the first.

Cheers Paolo

> I have 2 sets of combo boxes on my form where box 2 is set to only show the
> values that match with what was picked in box 1. My problem is the first set
> works great but the second set on box 2 will only show the first value no
> matter what you pick. I have looked to see if I can find any differances in
> the programming and they appear the same. What could I be missing. Thanks
> in advance

Reply to this Message

Alex Dybenko - 30 Oct 2007 12:37 GMT

Hi,
1. make sure you build correct criteria for second combo query
2. requery combo 2 after use changed value in combo1

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

>I have 2 sets of combo boxes on my form where box 2 is set to only show the
> values that match with what was picked in box 1. My problem is the first
[quoted text clipped - 5 lines]
> Thanks
> in advance

Reply to this Message

sandyL - 31 Oct 2007 11:35 GMT

I got it going thanks

> Hi,
> 1. make sure you build correct criteria for second combo query
[quoted text clipped - 9 lines]
> > Thanks
> > in advance

Reply to this Message