Karen Schaefer
asked on
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?
Thanks,
K
Thanks,
K
Sure.
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.Va lue
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
https://www.experts-exchange.com/Database/MS_Access/A_5949-Cascading-Combos.html
https://www.experts-exchange.com/Database/MS_Access/A_5950-Cascading-Combos-on-Continuous-Forms-and-Datasheets.html
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.Va
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
https://www.experts-exchange.com/Database/MS_Access/A_5949-Cascading-Combos.html
https://www.experts-exchange.com/Database/MS_Access/A_5950-Cascading-Combos-on-Continuous-Forms-and-Datasheets.html
ASKER
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?
K
K
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
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.
K
K
ASKER
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.
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.
ASKER
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.
see this link http://www.fontstuff.com/access/acctut10.htm