So I have been able to update the remarks field based off if there is an input in BC1Chng1....The code that was provided works great as along as I am in the orginal Remarks1 field. I want the user to do their inputs into BC1Chng1 field as those will change. I just want it to look at see if there is a value in BC1Chng1 for the remarks1 to copy down into those records. The Remarks in Remark1 field will always remain the same.
Here is the code: It copies down just fine ....But I need to be in the Orginal field where I type the Remarks into the Remark1 field.
Dim rst As DAO.Recordset
Dim strRemarks As String
Set rst = CurrentDb.OpenRecordset("Final_Table")
[u]strRemarks = Me.Remarks1[/u]
Do While Not rst.EOF
If Nz(rst![BC1Chng1]) <> "" Then
rst![Remarks1] = strRemarks
rst![Remarks1] = Null
The line where I have it underlined is the issue...It give me a Run-time error '94 Invalid use of Null