Email Current Record

[lrw0831]

I want to email the current record that I just entered. I created a report that I will email but when I send it, I receive all of the records, not just the one I entered.

How can I get it to just email that record?

[DonRayner]

I want to email the current record that I just entered. I created a report that I will email but when I send it, I receive all of the records, not just the one I entered.

How can I get it to just email that record?

Click the build button next to the reports record source property. Then in the query builder add criteria for whatever field will be unique for each record (Normally the primary key). Base that criteria on whatever control on your form is bound to that field.

or

Add a condition to the report open command, again based on a form control that is bound to a unique field.

Plus about 3 or 4 more ways that I can think of.