Error message with declaring variable as a FileDialog

[Busbait]

Hi

I am trying to declare a variable as a FileDialog object in VB for MS Access 2007

Dim fd As FileDialog

But, I am receiving an error message “ Compiler error : User-Defined type not defined”

Can you please help here?

[TheSmileyCoder]

You have to set a VBA reference to the Microsoft Office XX.0 Object library.

I don't know what XX version 2007 is, 2003 is 11.0 for comparision.

[NeoPa]

From the VBA window select :
Tools / References and search down the list for the appropriate reference.

[Busbait]

Thanks .......... it works fine now

[NeoPa]

Cool. Thanks for letting us know :)