Specifc report from a form

[Keith]

Hi,

I am trying to create a report that will email from a form
I have a form called Contacts this form is a data entry
screen which i would like to email directly to users.

Have tried to create a mail button and link this to a
query and report but cannot seem to find the correct VBA
to transfer the Contact_no which is a auto number field
and the info input against this number into the report for
emailing. Have tried the Docmd. openquery etc

this basically need to take the specific record that the
user is viewing and by clicking on a button set it up for
emailing.

 

[Howard Brody]

Create it as a Report and then use the SendObject command (in VBA) to email it to the user(s)
If you need it for a specific criteria (Contact_No), use a control on the form for the criteria and verify that it's been populated before you run/send the report


----- Keith wrote: ----

Hi

I am trying to create a report that will email from a form
I have a form called Contacts this form is a data entry
screen which i would like to email directly to users

Have tried to create a mail button and link this to a
query and report but cannot seem to find the correct VBA
to transfer the Contact_no which is a auto number field
and the info input against this number into the report fo
emailing. Have tried the Docmd. openquery etc

this basically need to take the specific record that the
user is viewing and by clicking on a button set it up for
emailing.