Dear all,

I have the following declaration in the top of a form:

Public my_global_Array As Variant


then, in a function, I want to check if this my_global_Array has "content" or not. In case it does not have content (it is null or it is nothing), I will load some data from recordset to this array.

But I dont know how to check if it is nothing. I have tried the following codes:

If (my_global_Array = "") Or (my_global_Arrays Is Null) or (my_global_Array is nothing) Then
call sub_load_rs
End If

It returns a fail message which says: "Object required."

What is the code for an variant is nothing?

Thanks