Email one record from a search form? (1 Viewer)

nancy54

Registered User.
Local time
Today, 06:30
Joined
Jun 19, 2018
Messages
49
Good morning,
I have a Split Form that allows the user to search for specific records. I want to add a button to allow the user to email that record. Using the macro builder on the Event control, it emails the entire object (query). How can I get it to email one record?

Nancy
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:30
Joined
May 7, 2009
Messages
19,169
Create a query with criteria based on th Form.
Use the query to SendTo.
 

Users who are viewing this thread

Top Bottom