Here is what I am trying to complish:
I want the code to look at BC1Chng1 if there is a value for it to copy the Comment in the Comment field to the other records where there is values in BC1. So it is looking at BC1 checking to see if a value is there and if yes repeating the Comments in the comment field.
here is my code for far
Private Sub UpdateAllComments_Click()
Dim memoContent As String
If Nz(Me.BC1Chng1, "") <> 0 Then
Do While Not Me.Recordset.EOF
memoContent = Me.Remarks1
Me.Remarks1 = memoContent
'Me.Remarks1 = memoContent
MsgBox "Already at last record"