vba code helping with overriding or updating fields as a form opens to current details

[ssanfu]

FYI,
the colon ":" is a line continuation token left over from the BASIC language. (back in the ancestral time of computers - the IBM XT )
It is still in VB/VBA for backward compatibility, but it has been depreciated.

This code

Private Sub txtQtyOfBackOrderReceived_AfterUpdate()
   If IsNull(Me.BackOrderReceived) Then
      [txtBackOrderReceived] = [txtQtyOfBackOrderReceived]
   Else   '<<-- notice no colon
      Me.txtBackOrderReceived = [txtQtyOfBackOrderReceived] + [txtBackOrderReceived]
    End If
End Sub

will still execute if written like

If IsNull(Me.BackOrderReceived) Then:[txtBackOrderReceived] = [txtQtyOfBackOrderReceived]:Else:Me.txtBackOrderReceived = [txtQtyOfBackOrderReceived] + [txtBackOrderReceived]:End If

BUT it is sooooo much harder to read.

The point being, it doesn't hurt anything, but you don't/shouldn't use it. Never know when MS will remove it from VB/VBA.

[ShaunG]

FYI,
the colon ":" is a line continuation token left over from the BASIC language. (back in the ancestral time of computers - the IBM XT )
It is still in VB/VBA for backward compatibility, but it has been depreciated.

This code

Private Sub txtQtyOfBackOrderReceived_AfterUpdate()
   If IsNull(Me.BackOrderReceived) Then
      [txtBackOrderReceived] = [txtQtyOfBackOrderReceived]
   Else   '<<-- notice no colon
      Me.txtBackOrderReceived = [txtQtyOfBackOrderReceived] + [txtBackOrderReceived]
    End If
End Sub

will still execute if written like

If IsNull(Me.BackOrderReceived) Then:[txtBackOrderReceived] = [txtQtyOfBackOrderReceived]:Else:Me.txtBackOrderReceived = [txtQtyOfBackOrderReceived] + [txtBackOrderReceived]:End If

BUT it is sooooo much harder to read.

The point being, it doesn't hurt anything, but you don't/shouldn't use it. Never know when MS will remove it from VB/VBA.

yeah right thanks for that, ive got it in other codes as well so ill get rid of it.. im pretty sure ms inserted it itself otherwise I wouldn't of known to use it lol