Using a query to send open record to report to email

J

JulieC

I want to be able to email the record that I am currently entering into a form. I created a control box set to run a query on my form and called it
bill_email. I used the following language in my query.
SELECT [Bill Summary].[Bill Number], [Bill Summary].Hyperlink, [Bill
Click to expand...
Summary].Sponsor, [Bill Summary].Summary, [Bill Summary].Analysis, [Bill
Summary].Background
FROM [Bill Summary]
WHERE ((([Bill Summary].[Bill Number])=forms!Bill_Summary!bill_email));

Bill Summary is the table, Bill Number, etc. are the fields. Bill_Summary is the form.

When I hit the control box in the form, I get the query data sheet view,
Click to expand...
and it is empty. Any ideas? Or any other ideas on how to email a current/open record from the form view. I am not a programmer, so I need specifics. Thanks
 
Top