Send a form

[Simon Dowse]

Hi,

Any ideas how I can set up a form (which I have already
created, and has the data entry property set to true)
which I can add records to and then when done these are
emailed to me?

The form can be free-standing, but I only want new records
to be emailed.

Any easy to understand ideas?

Simon

 

[Jim/Chris]

Add a field(checkbox) to your table indicating that the
record was emailed. Create a report based on the field
being null or "no". After the new records are emailed run
an update query changing the check boxes to "Yes"

Jim