I am currently trying to set up an email reminder in
access using the sendobject function in access. Right now
I have a form with 46 different entries with each entry
having about 16 fields. What currently happens right now
is that it goes through the 46 records and for a specified
field if the date entered in the field = todays date sends
out an email containing the form. However the form that
gets sent contains all 46 records. I am trying to apply a
filter that will only select the record which contains the
field that matches the condition and then email just that
one record. I have tried an apply filter function already
and recieved an error message. Any help would be greatly
appreciated
Thanks

Anon,

You should be sending out a report, not a form. And have the report
based on a query, and in the criteria of the query, refer to the
current record on the form, using syntax such as
[Forms]![NameOfForm]![YourPrimaryKeyField]

- Steve Schapel, Microsoft Access MVP


On Thu, 15 Jan 2004 10:11:08 -0800,
<(E-Mail Removed)> wrote:

>I am currently trying to set up an email reminder in
>access using the sendobject function in access. Right now
>I have a form with 46 different entries with each entry
>having about 16 fields. What currently happens right now
>is that it goes through the 46 records and for a specified
>field if the date entered in the field = todays date sends
>out an email containing the form. However the form that
>gets sent contains all 46 records. I am trying to apply a
>filter that will only select the record which contains the
>field that matches the condition and then email just that
>one record. I have tried an apply filter function already
>and recieved an error message. Any help would be greatly
>appreciated
>Thanks