CHOOSE 2ND COMBO BOX ONLY RELATED TO THE 1ST COMBO

[mickeync]

Hi,
I have the 1st drop down box called DIVISION which have 4 selection "GENERAL BANKING" "GOVERNMENT BANKING" "BROKERAGE" "WEALTH MGT". The 2nd drop down box called SUBDIVISION. On my form I want to select GENERAL BANKING from DIVISION, and in the 2nd box have a options are relating to just GENERAL BANKING and not the other options and if they choose DIVISION "BROKERAGE" or "WEALTH MGT" it will hide the Disabled the 2nd box since there's nothing to choose from. (See below)

DIVISION ==> SUBDIVISION
1)General Banking ==> Real Estate, Technology, HealthCare..
2)Government Banking ==> Commercial, Business, ....
3)Brokerage (No subdivision)
4)Wealth Mgt (No subdivision)


I would really appreciate any feedback on my questions. Thanks a bunch !!!

 

[rry2k]

You might want to try setting the row source for the boxes based on the selection. i.e. if selected = 1 then combo1.rowsource = query1, selected = 2 then query2 etc.
If you need help with the exact syntax let me know.

hth

 

[mickeync]

hi hth,
Thanks for the quick response. If you don't mind please help me with the exact syntax. I am using Acces 97. Thanks again ...

 

[rry2k]

Hi hth is hope that helps. How are you at righting queries. Try writing two queries which select the appropriate records based on the selection. I'm not sure if your subdivision stuff is in a seperate table or the same. Let me know and I will be able to help further.

Russ

 

[jbehrne]

Hi,

Try this link:

http://www.mvps.org/access/forms/frm0028.htm

It has sample code that will limit the contents of one combo/list box based on what's selected in another combo/list box.

HTH,

jbehrne If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

 

[mickeync]

Thank you all. I hope it works.