Determine if an object variable is set

[Brian]

How can I determine if an object variable is Nothing.

Dim appMapPoint as Object
Set appMapPoint = CreateObject("MapPoint.Application")Set appMapPoint =
CreateObject("MapPoint.Application")

Later.... Set appMapPoint = Nothing

Here is why:

I am automating MapPoint via Access/VBA. I always set the map application
object to Nothing when I close it; however, I now need to block certain user
functions (like opening another map) if the instance of MapPoint is still
open. I thought perhaps I could check the state of the Object variable.

Like a dummy, I tried this: If appMpoint = Nothing Then

....of course, to no avail.

 

[JimBurke via AccessMonster.com]

I think the correct syntax would be

If appMapPoint Is Nothing