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
and here is my code
Private Sub Email_Inbound_Report_Click()
On Error GoTo Err_Email_Inbound_Report_Click
Your query is referring to Me! but you use the query in the report!
Instead of "[ME]![Inbound_ID]", you should use "Forms!FormName!Inbound_ID" so that the query knows that you are referring to the value on the form.
(Of course, you must use the name of your form instead of "FormName")