2 Combo Box Help

  • Thread starter Thread starter Scott
  • Start date Start date
S

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

.
 
Back
Top