updating all the records in a filter

I have a form that is connected to a querry that contains
all of the records for this form. On this form I have 3
list boxes that is each filtered differently. I also have
a report that has the same filter that corresponds to the
row source for each list box. Under each list box there
is a print button that prints the report that corresponds
to the list box.

After the report is printed I want to save the date that
it was printed only for the records that are in the list
box/report. I will save the date into a record called
[Date Of First Letter], [Date Of Second Letter], and
[Date Of Third Letter]

The row source that I use for the first list box is:
SELECT [Status Members].[Full Name] FROM [Status Members]
WHERE [Number Of Letters Received]=0 And [First Letter]
="Feedback Letter";

I have a form that is connected to a querry that contains
all of the records for this form. On this form I have 3
list boxes that is each filtered differently. I also have
a report that has the same filter that corresponds to the
row source for each list box. Under each list box there
is a print button that prints the report that corresponds
to the list box.

After the report is printed I want to save the date that
it was printed only for the records that are in the list
box/report. I will save the date into a record called
[Date Of First Letter], [Date Of Second Letter], and
[Date Of Third Letter]

The row source that I use for the first list box is:
SELECT [Status Members].[Full Name] FROM [Status Members]
WHERE [Number Of Letters Received]=0 And [First Letter]
="Feedback Letter";
--------------------
For the first list box, you can use an UPDATE statement after the print
statement as follows:

UPDATE [Status Members] SET [Date of First Letter] = Date()
WHERE ([Number Of Letters Received]=0
And [First Letter] ="Feedback Letter");

Hope this helps,

--
Eric Cárdenas
Senior support professional

This posting is provided "AS IS" with no warranties, and confers no rights.