Edit Value in a list box
I have found your books really ROCK!
I hope that you can help me with something I have been pulling my hair out over for several days.
I am working in Access 2007.
I have a list box with 5 columns. I need to allow the user to edit the value in the 5th column. I tried:
me.lstbox.column(4,i) = var
However, that is not working.
From what I read on the internet, there should be a linked Edit form for the list box and an icon that appears to bring this edit form up, however, this icon never shows up for my list box. My list box row source type is Values List, the Allow value edits list is set to Yes, and the List Items Edit Form is populated with another form I created for this purpose. My guess as to why this is not working is because I am not using tables or a recordset.
Any advice or methods for achieving this result are very welcome!
Thanks in advance...