Hello all,
I have a form that I am using as a dashboard. There is a subreport that has data from a query that shows records that are due to have a postcard sent. The query returns records that have a date in one of the fields that is older than 7 days. There is another date field, Postcard_Sent, that, when present, will have those records no longer returned on the query.
I have a button on the form. I want to be able to click that button and have today's date populate to the Postcard_Sent field in each record on the subreport/query.
I tried
Code:
Private Sub cmdPostcardsSent_Click()
Forms!Dashboard.subPostcards.Form.Postcard_Sent.Value = Date
End Sub
Which fills in today's date on the top record, but not all of the records.
What do I need to change to have this field populate on all of the records that currently meet the query criteria and appear on the subreport?
Thanks in advance!