Click button on form to fill in today's date on subreport/query

[sephiroth2906]

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

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!

[xps35]

Try an update query.

DoCmd.RunSQL "UPDATE YourTable SET Postcard_Sent = Date() WHERE {your condition here}"

[sephiroth2906]

Thanks Peter. That did the trick!