updating all the records in a filter

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

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";
Click to expand...
--------------------
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,
 
Back
Top