Help with Update Query and Filter by Form

[Marco]

Hi Everyone
I have a Prospect List the I want to update via a Filter by Form or an
Update Query

The Data Base Contains a field "Last Date Email".

I created a command button with an update query that updates this field
with todays date.

I tried to use filter by form to select a portion of my Database and
ran the Update Query.

The problem is even though only the filter records are showing it
updates the entire DB. How can I have a Command button that runs an
update to a selected group of records.

Hope this makes SEnse.

Marco
Www.classactinsurance.com

 

[peregenem]

I have a Prospect List

The Data Base Contains a field "Last Date Email".

an update query that updates this field
with todays date.

Surely in a database of prospects you want to store the dates of *all*
emails (and other communications) sent? In which case,
most_recent_email for a prospect is a calculation e.g.

SELECT MAX(communication_date)
FROM Communications
WHERE prospect_ID = 42
AND communication_type = 'Email'

This would make your problem easier to solve i.e. simply make you
communication_date column be the current date/time when you INSERT
(create) the row.