Yes.  Covered in Access Developer 31.

I don't recommend jumping in in the middle though.  The courses are meant to follow in order so you have the prerequisites for that course.  I don't know what your experience level is with VBA.

To answer your question, it is possible with VBA, with the Dir() function to read file names from a folder.

Checked out Developer 31. Got the file picker to work but not the Dir function.

Any errors?

Doug -
Did you also download the sample db?  Does it work from there?
It works fine for me (The After L2 db ).  

So...  If it does, either you missed a step or typed something wrong.
Use the sample to compare what is there and what you have in your db.  Sometimes you get great learning of things by tearing apart an example.

Hi Doug, this should populate the list box with all the file names in a folder.  Only file names, not subfolders, are included.  

Private Sub PopulateListbox()
    Dim fn As String

    ' Get the first file name in the folder.  Note that wild card is used.  You can use wild cards to retrieve select files.
    fn = Dir("C:\My Folder\*.*")

    ' If found, run do loop.  Note: Dir() returns an empty string if no file is found.
    Do While Len(fn) > 0

        ' Add file name to list box.
        Me!MyListbox.AddItem fn

        ' Get next file name in folder.  Note: Dir() with no argument is used for this purpose.
        fn = Dir()

    Loop

    ' Number of file names in list box.
    MsgBox Me!MyListbox.ListCount
End Sub

Kevin, that worked. Thank you very much.

You're welcome.  Forgot to mention that the listbox RowSource must be set to "Value List".  You must know that already.