vba code?

[Sam Doder]

I am having a problem with the below vba macro code

    If IsNull(rs.Fields("ARC_MODEL").value) = True Then
    mstrModel = rs.Fields("Engine_Model").value
    Else
    mstrModel = rs.Fields("ARC_MODEL").value
    End If
    

What I am trying to do is assign the varible mstrModel with the value of arc_model if it is not null in the database and when it is assign engine_model to it instead.

It seems to be always getting assigned Engine_Model. Does anybody see something wrong with the above vb code.

I have modified the database with non null values for some of the arc_model columns in the resultset.


Thanks for any help.

[Campbell Ritchie]

Is the bit about = True required in VBA? InJava™ it would usually be regarded as bad style to write == true. Try missing out the = True.

Otherwise: very definite on't know!