Cascading Combo Boxes

  • Thread starter Thread starter Dorianne J via AccessMonster.com
  • Start date Start date
D

Dorianne J via AccessMonster.com

I have a form that lists the Bank Names, Bank Addresses, Bank City, Bank
State, Bank Zip, Bank Phone, Bank Fax, and Bank Contact. I would like the
combo boxes to only allow certain bank information based on which Bank Name
was chosen. Currently, I have to go throught the entire list for each line
to get the information needed. I am very new to Access so some of the
verbage is over my head. Any help for a beginner would be greatly
appreciated. Thank you in advance.
 
I think you can change the control source property of the combo box to a
query something like:
Select [the fields you want to show] form Banks Where [BankName = XXX]

The "control source" property can be found in the Data tag of its properties
window.
If you set more than one fields to show, you may want to check the Format
tag and set column count, header, widths.

Hope I understood your question,

Good luck!
 
Sorry, should be row source not control source .

gz said:
I think you can change the control source property of the combo box to a
query something like:
Select [the fields you want to show] form Banks Where [BankName = XXX]

The "control source" property can be found in the Data tag of its
properties window.
If you set more than one fields to show, you may want to check the Format
tag and set column count, header, widths.

Hope I understood your question,

Good luck!
Click to expand...
 
Back
Top