View Full Version : Emailing a Single report based on a query to the table!

01-30-2004, 06:45 AM
I am useing Access 2002 for this

So I have created a query to email a single report based on the data I have open in the form! problem is that when I click on the button to email the report it ask me what the Inbound_ID is I want that to be carried over for me how would I go about doing that????

Ok so here is my query!

SELECT Employees_Inbound_Query.Initials, Employees_Inbound_Query.Emp_First_Name, Employees_Inbound_Query.Emp_Last_Name, Employees_Inbound_Query.Inbound_ID, FROM Employees_Inbound_Query LEFT JOIN Employees_Soft_Skills_Inbound_Query ON Employees_Inbound_Query.Inbound_ID = Employees_Soft_Skills_Inbound_Query.Inbound_ID
WHERE ((([Employees_Inbound_Query.Inbound_ID])=[ME]![Inbound_ID]));

and here is my code

Private Sub Email_Inbound_Report_Click()
On Error GoTo Err_Email_Inbound_Report_Click

Dim stDocName As String

stDocName = "Email_Inbound_Report"

DoCmd.SendObject acReport, stDocName

Exit Sub

MsgBox Err.Description
Resume Exit_Email_Inbound_Report_Click

End Sub

what ddo I need to change so that it doesnt ask me which inbound_ID everytime??