Hi all, i'm a complete novice at access so please Bear with me. My Q'n is as follows: I have a simple database with numerous records. I want to be able to email individual record information to a work colleague via a command button. I have tried to do this and have managed to get the email working but the record report contains ALL of the records. How can I set this command button up to just send the record on it's own ?

I hope someone can help
kind regards
nocky1972

What about clearing out and re-populating a temp table with just the record you need, and sending that data table?

Hi there, sounds like a plan but I wouldn't have a clue on how to do it. Is there a simpler way? Surely individual records can be printed; can this principle be adopted for emailing from a form?

Regards
nocky