Run a query to pull up a specific record using the parameter value [??add
unique value???], base a report on that query, then add a command button to
your form which will send report via email (best format is snap shot, anyone
with access will be able to view them automatically, if they do not have
access you can get a small exe file from microsoft downloads to install the
snap shot viewer which will run without access).