I would like to put a button on my form to email a single report. I have looked around and tried several of the examples on this forum, but keep getting a "data type mismatch in criteria expression". If someone could explain to me how to set this up to work to email only the current report in the form I would appreciate it.

frmaction
qryaction
primarykey: tblanalysisnumber

Thanks
Tracy

Why don't you post the code you're trying and we'll figure out why it's throwing an error.

Well I gave up on the previous and went with a macro instead which works, only problem is it emails all records, I only want the specific record showing in the form at the time. Anything I can add to make this happen?

The report would need to restrict itself to the record on the form, either in its source query or via filter.