sam111
12-13-2010, 01:24 PM
For my job I was handed a project that uses word vba macros to create a microsoft word report document.
I needed away if the database has a non null arc_model field to set the variable of mstrModel to that. However when I debug it always gets set to the engine_model field.
Does anybody see anything wrong with the below code for this logic
If IsNull(rs.Fields("ARC_MODEL").value) = True Then
mstrModel = rs.Fields("Engine_Model").value
Else
mstrModel = rs.Fields("ARC_MODEL").value
End If
Thanks for any help
I needed away if the database has a non null arc_model field to set the variable of mstrModel to that. However when I debug it always gets set to the engine_model field.
Does anybody see anything wrong with the below code for this logic
If IsNull(rs.Fields("ARC_MODEL").value) = True Then
mstrModel = rs.Fields("Engine_Model").value
Else
mstrModel = rs.Fields("ARC_MODEL").value
End If
Thanks for any help