So my boss has asked me to have my comment field "Remarks" get copied into one other record.
So when the user inputs data in my "value" field, the user needs to leave a comments as to why. So they would type in the first comment. Another record that may need another value change will require the same comment. She wants it to be able to take the first comment and copy it into the other comment field in the second record. I have no idea on how to do this. I was able to copy the comment into all my records into my table..But that is not what I want or need. I am not good at coding.
Private Sub UpdateAllComments_Click()
Dim strMsg As String, strQry As String, strRemark As String
strMsg = "Update All Comments in the Current view. IMPORTANT!!! Will update a the filtered records."
If vbYes = MsgBox(strMsg, vbYesNo, "IMPORTANT!! Confirmation") Then
strMsg = "Please enter the remark"
strRemark = InputBox(strMsg, "Remark")
If Len(strRemark) > 0 Then
strQry = "Update Final_Table set UpdatedDate = now(), UpdatedBy = """ & txtWelcome & """, Final_Table.Remarks1 = Allot_Q.Remarks1"
'& '--" & strRemark & "'"
QuickQry strQry, False
MsgBox "Action cancelled."
I have my records queried to show only a handful of records..but the comments get copied to everything in the table.