Creating a Browse Button on an Access Form VBA

I am trying to create a simple "browse" button in which it opens a directory tree and filters images (.jpg or .bmp) out of it. I started coding it below but it is complaining that "dlg.SelectedItems" is not optional. Can someone help me fix this and add the filters to this code as well. Also after selecting the the image from the directory how can I display that image on the form? I will have the path, is there some control that I can add to my Access form to display it?

Thanks in Advance
Option Compare Database
Option Explicit
 
 
Private Sub btnBrowse_Click()
Dim dlg As FileDialog
    Dim strFilePath As String
 
    Set dlg = Application.FileDialog(msoFileDialogFolderPicker)
 
    
        If dlg.Show = -1 Then
 
            'COMPLAINS HERE SAYS "AURGEMENT NOT OPTIONAL"
            strFilePath = dlg.SelectedItems
 
        End If
    
    
    Set dlg = Nothing
    
    txtPath = strFilePath
End Sub

Open in new window

npl77Asked:
Who is Participating?
 
takendownConnect With a Mentor Commented:
Perhaps this will help.  The second example more specifically.

http://www.instantpages.ltd.uk/Office_FileDialog.htm

Maybe someone can provide a better answer :)
0
All Courses

From novice to tech pro — start learning today.