cascading combo boxes again

[dave@homedeliverygroup]

I had to re-post this sorry to keep it towards the top... i have tried
countless times and countless suggestions and different codes... that i can't
remember what i used anymore... I am usally good at figuring things out...
but this i can't get for some darn reason... my database is very easy and not
a complex DB at all which is really bothersome to me that i can't get this to
work that i have broken the stores down now to serveral different tables...
each represent their own market EX: MA, CT, MD, VA, ATL and DE seven tables
with the stores in each instead of one big table of stores would a CASE
statement in the after update of "market" be better? I don't know... just
need the store and loctation combo box to display only the store for the
market selected in the market box...

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

 

[Golfinray]

Try Martin Greene at www.fontstuff.com or Allen Browne at www.allenbrowne.com
Both have excellent tutorials on your problem.

 

[dave@homedeliverygroup]

Ahhh i guess i will try another way... guess i am an idiot just can't seem to
get any example to work... i thought this would be easy "get one box to
display from what is select in the first box" sure as heck sounded simple
enough! going to just use one box with 210 stores, and growing, and just
deal with user entry error... i guess