emulate Web DropDown select in Access 2010

I am looking for a way to emulate the web form drop downs, allow the user to select 1 item (List1), List 2 appears to right - similar to short menu, allowing the user to continue to narrow down their selection, so forth. all accomplished within an Access form.  is there any code or objects that would allow me to accomplish this?


Karen SchaeferBI ANALYSTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
in access, it is called cascading combo boxes, or cascading lists

see this link http://www.fontstuff.com/access/acctut10.htm
That's been done many, many times.
The search term is 'MS Access cascading combobox'
Bascially, you set the rowsource of each succeeding combobox to be
"Select ThisID, GoodThingsToDisplay Where SomeID = " & Me.SomePreviousComboBox.Value
You wire up each combobox's AfterUpdate Event to requery its successors.

The complication is that users may go back in the order and change their minds.
Then you may have to reset everything downstream again.
@harfang writes excellent articles
Karen SchaeferBI ANALYSTAuthor Commented:
Rey,  I know about cascading combos and cascading list, I was hoping for the  look and  feel of a web page with the popup menu type  or selection for the combos.  Limiting the need for additional combos all over the form.  I like the feel of selection on a web page, where depending on your selection, a right menu pops up and allows the user to continue to make further selections.  Do you know if this is possible?
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

A url of a site that does that would be good for comparison.
That kind of thing isn't impossible in Access.
You have control of the RowSource, ControlSource, Caption and Visible properties.
If you wanted to give a user a 'back' and 'next' and use a single combobox for selection and hold the values in invisible controls/form level variables/temp data tables you could.
Your control is then just a shell and you code all of it on the fly.
A fair bit of work, but doable.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Karen SchaeferBI ANALYSTAuthor Commented:
Nick thanks for the suggestions, however, not quite what I am looking for - I wish to have the second selection item come from a hovering menu type of drop down - similar to those used on a web page.
Karen SchaeferBI ANALYSTAuthor Commented:
Nick thanks for your input, just saw you last comment, any idea where I might find a bit of code that could point me in a similar direction.  any suggestions are greatly appreciated.

Karen SchaeferBI ANALYSTAuthor Commented:
is it possible to incorporate Web Services forms' objects into a regular form?
s it possible to incorporate Web Services forms' objects into a regular form?
I am uncertain what you are asking, but even then I wouldn't know.
For me, Access meets the web only at the database.
ASP.Net does the web, Access does the LAN

I wish to have the second selection item come from a hovering menu type of drop down
Forget hovering, but you could have two listboxes, side-by-each, and a 'back' button.
The first AfterUpdate event in the listbox on the left would make the right-hand one visible.
The right-hand AfterUpdate would throw its configuration into the left-hand listbox, and prep a new RowSource for itself.
Karen SchaeferBI ANALYSTAuthor Commented:
thanks for the info - gave me something to think about when time comes for design - I am still in the develop/requirements phasae of my project.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.