basing one combo box on another

[Guest]

I have found a great deal of info on this subject but I cannot get darn thing
to work. I have a form: instruments, with a combo box:inststate, this box is
populated by a statement in row source SELECT tmst.state FROM tmst GROUP BY
TMST.STATE ORDER BY TMST.STATE; row source type is table/query, control
source is inststate, tmst is a table that houses all states and their
counties, state is listed beside every desc(county) that's why the group by.
I have a second combo box instcounty a, row source SELECT TMST.STATE,
TMST.DESC FROM TMST WHERE (((tmst.STATE)=FORMS!INSTRUMENTS!INSTSTATE)); row
source type table/query, control source is instcounty a. Hopefully I have
given enough info for help but if not let me know. I have used examples and
everything from the ms web site and I am just plain not getting please
Helllpppp!

GCG

 

[Guest]

no comprendo....

rather than code - please restate in plain english what you hope to have....

 

[Guest]

Sorry for the garble. I have a form instruments based on a table
instruments, and on that form I have two combo boxes, inststate and
instcounty A. I want the user to select inststate which is bound by a select
query based on a table tmst.(the data in tmst is a listing of FIPS codes,
states, counties etc.), the query selects state, groups on state and orders
by state, this works just fine. I want the selection made in the inststate
combo box to filter the return for instdesc box ( which is counties in the
state selected in the inststate combo box. My return now is asking me for
what state, or in other words isn't reading the combo box inststate. I have
been working from some great material it all seems straight forward but I
cannot get over the hump. I thought maybe the group by in the first combo
box might be causing a problem but I cannot figure it out. Thanks for the
help.

Gary

 

[Guest]

If you search in this site you will find alot of other strings involving your
need of having a combobox set based upon the prior selection of another
combobox.

As it sounds like your second combobox is not getting the State info it
requires - you need to double check that the State info is the field being
bound in the first combobox.

If you are sure it is - sanity check your syntax by whipping up a simple
temporary textbox and temporarily base your second combobox on the value in
this textbox and enter the state info yourself manually - - and see if it
works...

At this point it is not clear if you have a concept problem (I don't think
so...) or just an implementation mistake....

 

[Guest]

Thanks you were right. The wrong column was bound in the state box. Thanks a
million.