Invalid use of NULL (?!!)

[mikewood1980]

Hi

Can anyone help me with this - I keep getting an error on the line marked *** "Invalid use of NULL". The only way that the code can reach this line is if rsWallCons("intLeafID2").Value is NOT null - how is this possible?!!?

If rsWallCons("intLeafID2").Value = Null Then
                    MsgBox ("we dont have a wall")
                    intLeafID2 = 0
                Else
                    intLeafID2 = rsWallCons("intLeafID2").Value
                    
                End If

Can anyone help?

Thanks
Mike

 

[namliam]

Double post