array invalid use of null

[matrixindicator]

I have a two dimension array. He gets the data from a table. Array CargoOn(i, 1) has always a value because for every record there is a value. Array CargoOn(i, 2) does not always have a value, because sometimes for a record there is not a value (NULL). When running the code he saids, "invalid use of null". What do I need to do ?

rst.MoveFirst
i = 1
For i = 1 To rst.Fields(0)
    CargoON(i, 1) = rst!cargo_cont
    rst.MoveNext
Next i

i = Empty
i = 1
rst.MoveFirst
For i = 1 To rst.Fields(0)
    CargoON(i, 2) = rst!CARGO_
    rst.MoveNext
Next i[Code]

 

[TomCologne]

In VBA Help look up "Nz Function".

TomCologne

 

[JerryKlmns]

Or

CargoON(i, 2) = rst!CARGO_ &