email current record from a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a database that allows users to request a new part number be created. There is a control for "send to doccontrol" which automatically allows the user to send the new part number request to me. Only thing is, it's emailing (in excel format which is fine) every records from the database. How do I set up the control or a macro that will send only the current record / form that is being input?
 
SNL,

Do you know the procedure or mechanism by which the Excel file is being
created? Whatever it is, it needs to be based on a query which uses a
criteria to isolate the record you require. Probably can't be more
specific without more information about what the database is doing.
 
Steve

I'm using Microsoft access. I have designed the form to send the file to me as an excel spreadsheet attachment. I am trying to figure out how to specify that only the current form (record) that is being entered is emailed to me instead of the complete underlying table

Thank you for your help

snl@re

----- Steve Schapel wrote: ----

SNL

Do you know the procedure or mechanism by which the Excel file is being
created? Whatever it is, it needs to be based on a query which uses a
criteria to isolate the record you require. Probably can't be more
specific without more information about what the database is doing
 
SNL,

Probably the most straightforward approach is to export to the Excel
file from a query, and in the criteria of the query, refer to the
identifying field from the current record of the form, using syntax such
as [Forms]![NameOfYourForm]![NameOfField]
 
Back
Top