<div>
Have you set the RowSourceType property to a Value List?<br />
Cheers, Andrew
</div>


Have you set the RowSourceType property to a Value List?
Cheers, Andrew

<div>
<div class="content wysiwyg-content">
I load my listbox with the following code:<br />
Private Sub Form_Load()<br />
Dim fso As New IWshRuntimeLibrary.FileSys<wbr />temObject<br />
Dim fld As Folder<br />
Dim fil As File<br />
Me.lstFiles.RowSource = &quot;&quot;<br />
Set fld = fso.GetFolder(gstrMediaFol<wbr />der)<br />
For Each fil In fld.Files<br />
&nbsp; &nbsp; Me.lstFiles.AddItem fil.Name<br />
Next fil<br />
End Sub<br />
<br />
The listbox is filled with the names of the files in the folder but I cannot select an item and listindex appears to be stuck at -1
</div>
</div>


I load my listbox with the following code:
Private Sub Form_Load()
Dim fso As New IWshRuntimeLibrary.FileSystemObject
Dim fld As Folder
Dim fil As File
Me.lstFiles.RowSource = ""
Set fld = fso.GetFolder(gstrMediaFolder)
For Each fil In fld.Files
    Me.lstFiles.AddItem fil.Name
Next fil
End Sub

The listbox is filled with the names of the files in the folder but I cannot select an item and listindex appears to be stuck at -1

Select from Listbox in Access 2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.