I have a data entry form that I use for tracking patient complaints. In an
earlier version, (not designed by me), there was a command button that, when
pressed I could preview the individual form that I was working on and then
send it via email (snp format). I took a few Access courses and redesigned
the input form and have now lost the capability. Whatever I attempt it ends
up emailing the entire database. I can't seem to choose a particular form.
Can anyone help?

If you have a copy of the database before you made your changes (you did make
one didn't you?), examine the OnClick event for the command button. That
should tell you how the email was previously sent.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Janeyd54" wrote:

> I have a data entry form that I use for tracking patient complaints. In an
> earlier version, (not designed by me), there was a command button that, when
> pressed I could preview the individual form that I was working on and then
> send it via email (snp format). I took a few Access courses and redesigned
> the input form and have now lost the capability. Whatever I attempt it ends
> up emailing the entire database. I can't seem to choose a particular form.
> Can anyone help?