Cascading Combo boxes HELP!!!!

[dave@homedeliverygroup]

I know this has been asked several 100 times about cascading combo boxes
where one box is populated by another... but i can not figure it out... even
if someone had a gun to my head.... seems like it should be easy however i
just can't get it...

i have two combo boxes
1 named "market" which list my markets and has field names: "count"(auto
number) and "market" based off marketTbl and the format is as follows:
count market
01 DE
02 ATL
03 MA
04 NJ


the 2nd one is "store # and location" this contains my store number along
with the location of the store and has field names: "hub ID"(FYI market from
#1 is the same as hub ID) "store # and location" based off storesTbl... and
the format is as follows:
hub ID store# and location
DE 0217 Newark
DE 0622 N Wilmington
ATL 0033 Atlanta

this is a small sample there are 210 stores in the storeTbl but i need it to
only show the stores that are specfic to the hub id when the user select DE
as the market Ex: DE i need only the DE stores to be available in the stores
combo box...

ANY HELP IS GREAT APPREICATED....

 

[dave@homedeliverygroup]

do the combo boxes have to be unbound????

what is the difference?????

 

[Jeff Boyce]

Rather than focus on 'button-pushes', I'll offer a generic outline...

When the first combobox has an item selected, the query that "feeds" the
second combobox needs to re-run, using the value selected in Combobox1 as a
selection criterion.

For this to work, you need:
* a query that points to the combobox1 for a selection criterion ... and
this query feeds combobox2
* a way to tell the query to re-run ... the AfterUpdate event of combobox1
needs something like: Me!cboCombobox2.Requery

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP