having difficulty with this, keep getting Object Required
Code:dim SN as String If me.FldLoop1 is not null Then SN = me.FldLoop1 Else: SN = me.FldLoop2 End If
having difficulty with this, keep getting Object Required
Code:dim SN as String If me.FldLoop1 is not null Then SN = me.FldLoop1 Else: SN = me.FldLoop2 End If
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.
FldLoop1 Ιs Νot Νull in SQL.
In VBA: Not IsNull(Me.FldLoop1)
So, the correct syntax is:
Usually, I prefer:Code:If Not IsNull(me.FldLoop1) Then SN = me.FldLoop1 Else SN = me.FldLoop2 End If
Saves one comparison.Code:If IsNull(me.FldLoop1) Then SN = me.FldLoop2 Else SN = me.FldLoop1 End If
AWESOME! Thanks so much!