Hi,
I made a very simple macro see below:
Private Sub Command27_Click()
If Date_HOP = Date Then
Texte19.Value = txt_BC
End If
End Sub
it is working as intended, but it only does that for 1 record.
the thing is whenever I put a date on a record, we always need to put that same 8 digit in the comment field.
so I created a text field called "txt_BC" where we write our 8 digit say (12345678), and with the click of a button, id like that 8 digit to be in every record where the date box contains a date.
the macro upthere works as intended but only for 1 record. anyway to make it for every record that contain a date in that field and put that 8 digit in this comment box ?