T
tuesamlarry
I Have looked at many examples but believe mine is a bit different.
Combobox1 lists services such as Food, Utilities, Clothing. I want the
second Combobox2 to list those Agencies I can refer clients to. A given
agency may show up for any or all the services. I do not want to create one
table which lists each Agency (multiple times) for the different services
they may or may not provide. I have one Table listing the agency with Yes/No
columns for services provided. This will enable administrator to easilly
check whether a given agency currently supports particular service. Therefore
it appears I would need a separate row source query for each service in
Combobox1 to show list of available Agencies in Combobox2. Have played a bit
with using Select Case in the AfterUpdate event of Combobox1 without success.
Even with one case scenario am unable to "tell" Combobox2 its rowsource comes
from Combobox1. Do the Comboboxes need to be unbound? Would appreciate advice.
Larry
Combobox1 lists services such as Food, Utilities, Clothing. I want the
second Combobox2 to list those Agencies I can refer clients to. A given
agency may show up for any or all the services. I do not want to create one
table which lists each Agency (multiple times) for the different services
they may or may not provide. I have one Table listing the agency with Yes/No
columns for services provided. This will enable administrator to easilly
check whether a given agency currently supports particular service. Therefore
it appears I would need a separate row source query for each service in
Combobox1 to show list of available Agencies in Combobox2. Have played a bit
with using Select Case in the AfterUpdate event of Combobox1 without success.
Even with one case scenario am unable to "tell" Combobox2 its rowsource comes
from Combobox1. Do the Comboboxes need to be unbound? Would appreciate advice.
Larry