object required

[mainerain]

having difficulty with this, keep getting Object Required

 dim SN as String

If me.FldLoop1 is not null Then
SN = me.FldLoop1
Else: SN = me.FldLoop2

End If

[orange]

Please show all of the related code.
Sub or Function; appears to be part of some Form or Report Event???

An overview showing the context for your question will help you get focused responses.
Good luck.

[accesstos]

FldLoop1 Ιs Νot Νull in SQL.
In VBA: Not IsNull(Me.FldLoop1)

So, the correct syntax is:

If Not IsNull(me.FldLoop1) Then
    SN = me.FldLoop1
Else
    SN = me.FldLoop2
End If

Usually, I prefer:

If IsNull(me.FldLoop1) Then
    SN = me.FldLoop2
Else
    SN = me.FldLoop1
End If

Saves one comparison.

[mainerain]

AWESOME! Thanks so much!