Sub-Value Lists?

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi there,

I am putting together an Access database and am wondering
if it is possible to install sub value lists. Right now, I
have one value list that
features "Sales";"Marketing";"Logistics", etc. and would
like to have it so if "Sales" is highlighted, a sub-menu
would appear that would read "Brokerage";"State Markets",
etc. Is this possible? And if so, how could I do this?

Thanks for your help in advance,

Steve
 
To do this correctly, you should be driving your lists
with queries that draw their values from tables. Having
said that, the direct answer to your question is to use
the AfterUpdate() event of your existing control to
dynamically populate the 'RowSource' property of your
second control

Sub MyControl_AfterUpdate()
Select Case Me!MyControl
Case "Sales"
Me!MyControl2.RowSource = "Brokerage;State Markets"
Case "Marketing"
Me!MyControl2.RowSource = "Option3;Option4"
Case "Logistics"
Me!MyControl2.RowSource = "Option5;Option6"
End Select
End Sub

good luck.
 
Back
Top