Trouble with FileDialog Method

[bhujanga]

I'm using the exact code in two different forms. In one form it works fine, on the other I get this message:

Method 'FileDialog' of object'_Application' failed

This is the code:
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.InitialFileName = Path
.Show
rtnFile = .SelectedItems(1)
End With

I haven't the slightest idea what it is not liking. Any suggestions?
(I'm quite certain the Path is not the problem)

 

[UnsolvedCoding]

Check to see if your scripting is referenced.

 

[UnsolvedCoding]

If you are in the VBA editor go to Tools > References and look for Microsoft Scripting Runtime. If its not checked, check it and try again.

 

[bhujanga]

I checked it and I still get the same message. Is there a better way to open the file selection screen? My goal is just to save the selected filename including its path in a field.
Thanks.

 

[combo]

What application? You need a reference to Microsoft Office xx.0 Object library, it's not default in ms access.

combo

 

[bhujanga]

I'm using Access. It's working perfectly in another database I wrote a couple years ago. But I can't get it to work in this one. They're both running on the same group of PCs.

 

[combo]

So try to add a reference to the Microsoft Office library in the access file.

combo