Email Singe Record in a Report 1

[BLBurden]

I have a Database name "FCSTICKETS" in this form db I have the fields Ticket# CustomerID, Dates opened/closed, Emails etc..... This DB is use for tracking trouble calls as the are phone in daily, so there are several record that being entered. When I receive a call I enter it, and in turn have to send an email to the person who called to let them know that their call hase been opened/closed.

Since I am entered serveral records per hour/day, is it possible to just email the one record of the person who called? I have set up my codes for emailing but when I send it all the records in the DB are sent, and I just want the one record to be sent of the present call.

Is there anyway I can associate the Ticket# or CustomerId with the EmailAddress to just send that record?

Please help if you will. Thanks

 

[PWise]

bind your report to a query name
i.e. your reports recordsource should be a query
in the on click event of your button
dim mydb as database
set mydb=currentdb
mydb.querydefs("reportqueryname&quot.sql=select ...... from tablename where [Ticket#]= & me.[Ticket#] & ";"
docmd.sendobject "reportname" ........

 

[BLBurden]

Thanks PWise, I guess i am not just cut out for vb coding, I used your above example and tried and tried to make it work with my DB and still could not send one record at a time.

I am just a very basic user, I know nothing about most of the coding, most of the time I just luck upon things.

But I do know how to use the Docmd method and that works fine but it send all the records. I will just have to cut the unwanted record befors sending the email.

THANK AGAIN.