For some reason when I am attempting to declare a variable as FileDialog I am getting an error: "Compile Error: User-Defined Type Not Defined"

Anyone familiar with this situation?
Thanks in advance for any help you could lend.



This is my code:
Sub MapDataDb()
    Dim UsFile As Variant
    Dim UsItem As String
    Dim UrAdd As Variant
    Dim UrName As Variant
    Dim CheckUeFam As Variant
    Dim fd As FileDialog



BrwsNew:

Access.FileDialog(msoFileDialogFilePicker).Show

It looks like a missing reference error. From the VBA Editor, Tools > References > Microsoft Access 11.0 Object Library and Microsoft ActiveX Data Objects 2.1 Library. I think that will do it.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com