Drill down functionality on list boxes

Resolved · High Priority · Version 2003

Fri 5 Sep 2008, 15:44 Delegate Richard said...

Richard has attended:
Access VBA course

Drill down functionality on list boxes

Would like to get coding so I can select an item within a list box and open a relating form in VB

Fri 26 Sep 2008, 13:07 Trainer Laura said...

RE: Drill down functionality on list boxes

Hi Richard

Thanks for the question, I hope I have an easy answer to solve it.

You need to add code to the event Change on the combo box. Here is a simple example.



Private Sub cmdFormName_Change()

    Select case me.cmbFormName

case "Menu"

DoCmd.OpenForm "frm Menu"

case "Options"

DoCmd.OpenForm "frm Options"

End Select

End Sub

Does that help?

Laura GB

Fri 26 Sep 2008, 14:59 Delegate Richard said...

RE: Drill down functionality on list boxes

Hi Laura,

Thanks for the reply. I didnt explain myself too well. The issue im having is when there is more than one column within a list box (not a combo). I need to know how to get vba to pull out a partucular value within a specific column. The example im using at the moment has about seven columns.

Kind regards,
Richard

Mon 10 Nov 2008, 08:49 Trainer Laura said...

RE: Drill down functionality on list boxes

Hi Richard

I think I have a neat solution for you although its not an obvious one. Here is an example that will msgbox the third column, (first column is column 0). This will work for list boxes that have single or multiple selection allowed.



Dim ListItem As Variant

For Each ListItem In Me.MyListBox.ItemsSelected

    MsgBox Me.MyListBox.Column(2, ListItem)

Next ListItem

I hope that helps.

Laura

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips