Send Object Macro

[Guest]

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

 

[Steve Schapel]

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