2 Combo Box Help

[Scott]

Is it possible to make 2 combo boxes based on 1 table show
information? The way I have my table set up now is one
City, State per field to avoid duplicate city names. What
I would like to do is have the user first select the
state, then select a city that has been fltered by the
first combo box, then for them to open another for or
report based on the state and city choice. Thank for your
help.

 

[Sandra Daigle]

Hi Scott,

It is fairly simple to synchronize two combos. Have yo seen this KB article:

ACC: How to Synchronize Two Combo Boxes on a Form (97624)
http://support.microsoft.com/default.aspx?scid=kb;[LN];97624

 

[Guest]

No, I sure havent, but Ill give it a try. Thanks Sandra

-----Original Message-----
Hi Scott,

It is fairly simple to synchronize two combos. Have yo seen this KB article:

ACC: How to Synchronize Two Combo Boxes on a Form (97624)
http://support.microsoft.com/default.aspx?scid=kb; [LN];97624


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Is it possible to make 2 combo boxes based on 1 table show
information? The way I have my table set up now is one
City, State per field to avoid duplicate city names. What
I would like to do is have the user first select the
state, then select a city that has been fltered by the
first combo box, then for them to open another for or
report based on the state and city choice. Thank for your
help.

.