Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: Visual Basic
Expertise: Beginner
Jan 18, 2000



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Cascade/Tree Menu

I have an Access database in which I would like to place a tree menu in a form. In this tree menu you would be able to make a selection and it would fill the table with the desired selection. An example of what I am trying to explain would be:
Casualty Type >  Mechanical > Engine
                > Collision > Weather
                            > Negligence
                            > Drugs
                            > Alcohol
I am not sure I am giving you a great example but I was also wondering if I could use a cascade menu with VB for this situation, and if I use VB, how do I place it into the database from the VB editor?

The idea behind the tree or cascade menu is to have the user select a type (i.e. mechanical) which would open up the reason (i.e. engine) which would place the reason into the section (i.e. casualty type) on the table.

You can certainly create a popup menu with those choices—that shouldn't be a problem.

What you then have to do is to respond to menu clicks by storing data into the field where the cursor is. You can store a reference to the control in a generic object variable during the GotFocus event. You then store the data into that control when the user clicks a menu choice.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date