test to see if filedialog has been SET

[GraeagleBill]

Compiler complains if I try

If fdMyFileDialog = Nothing Then".......

And,

If IsObject(fdMyFileDialog) Then"........

executes okay, but doesn't seem to respond even when I know if the object has been set.

So, what's the best way to determine if the object has been set? Google "pointed" to the latter more often than not, but still.

[Minty]

Not the answer you are quite seeking, but I normally set a text box to the full path of the file(or folder) as a visual clue to the end user that they have picked the correct thing, then test that for some useable contents?

[Gicu]

This seems to work for me:

Dim obFileDialog As Office.FileDialog


If obFileDialog Is Nothing Then
MsgBox "Not SET"
End If

[GraeagleBill]

Ah yes! Most of the time Access likes "=" and sometimes it refers "Is". Sort of depended on whether the language developers knew each other.

[Micron]

I think the struggle could be helped with a bit of study on comparison (logical) operators, and I'm saying that because likely there is a lot more to it than you ever imagined. WRT to = vs Is, you probably know that nothing = null, but the same can be said for Nothing, which is what we SET an object variable to when we want to empty it. Something that doesn't exist can't equal anything, can it? Thus we use Is, which can be true or false.