How can I choose an individual form from a database and email it?

[Janeyd54]

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?

 

[Arvin Meyer MVP]

Save the form as a report and send the report. Use SendObject to email it
(code should be in the helpfile). That said, emailing patient information is
generally unacceptable under HIPAA rules unless there's nothing connecting
that data to an individual. So for instance if your recipient had data
stating that PatientID 6712 was Jane D. Then you could email info for
Patient 6712, as long as there were no address, phone, SSN, etc. in that
data. You can, however, send the report as an encrypted Zip file, or encrypt
the entire email.

 

[Janeyd54]

Unfortunately that didn't work. I did what you suggested, but again it
copied the whole data base and I cannot choose a specific record. Any more
suggestions?

Also, we are well aware of HIPPA, there is no patient information involved,
and these are strictly internal documents. Thank you for the warning. It's
is very important and needs to remain at the forefront.

 

[Arvin Meyer MVP]

You open the report as 1 record. The recordsource of the report must read
the PatientID from the form.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com