MS Access: ListView ItemClick

[AnotherRookie]

Guys, I need some help as I am a real rookie in MS Access programming and is currently struggling with a ListView issue. I am populating the listview from a table and want to create the functionality to click or double click on a row upon which it then opens a dialog box in which I enter a value that is then saved in the first subitem of the selected row. I managed to get to the point where open the dialog box when an item is clicked using ListView_ItemClick(...). But, what do I need to do in order to identify the exact row selected and then enter the new value into the subitems(0)? I hope you understand what I am asking because I am also not sure about the terminology.

 

[dhookom]

Are you using a listbox control? If not, why since these native Access controls are much easier or "rookie" programmers to use.

Duane
Hook'D on Access
MS Access MVP

 

[AnotherRookie]

No, I created a form, and in this form I have a ComboBox (Product list) and ListView (List of workstations and sections) with three columns. The product selection in the Combobox fills the listview with values of workstations and sections. The user then needs selects a number of these rows and each row must be assigned a sequence number that will be used to determine the production path in the manufacturing process. The number of workstation vary from product to product and I thought that a ListView would work best. But, as you clearly know it is quite difficult for an inexperienced programmer.

 

[AnotherRookie]

Okay, using the following I manage to read the row's subitems. But, Trying to write to the first subitem gives me and error.
Private Sub ListView4_DblClick()
Dim ObjList As ListView
Dim objItem As ListItem
Set ObjList = Me.ListView4.Object
Set objItem = ObjList.ListItems.Add()
[highlight #FCE94F] objItem.SubItems(0) = "1"[/highlight]
MsgBox ObjList.SelectedItem.SubItems(1) & ObjList.SelectedItem.SubItems(2)
End Sub

 

[MajP]

Pretty sure you need to add the sub item first. You are assigning a value but it does not exist yet.