Combo boxes

[arkres]

Hi,

I'm not a database developer, so I really need someone's help with this. I have a combo box containing "ProgramType". If "DDI" is selected from this combo box, I would like it to open up another combo box containing the contents from "tblDDI". Then I would like the selection to be transferred to "ProgramType". Is this possible? Can someone give me the code for this? I would really appreciate it. Thanks so much.

Pat

 

[jdraw]

What you are describing is Cascading Comboboxes.
Here are 2 free video tutorials that should help.
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

 

[arkres]

Thanks for these. Is there a way to accomplish this with VB as well?

 

[jdraw]

Please tell us more. By VB do you mean VBA? If you watch the videos, you'll see some vba used.

 

[arkres]

After watching the videos, I'm thinking that I don't really need cascading combo boxes because the two tables aren't related. In other words, I think that I would need to restructure the tables first in order to make this work. Thanks for you help.

 

[jdraw]

Perhaps you should tell us more about your application. The key to database is to get your tables and relationships designed to meet your business need.