Query Current Record Only to be sent Via E-Mail

[System Administrator]

How can I query the current record only and have it sent via e-mail with the
click of a command button?

 

[[MVP] S.Clark]

In the query, put criteria like:

WHERE [Field] = Forms!FormName!Controlname

Sending things in an email is accomplished with SendObject or Total Access
Emailer: http://fmsinc.com/products/emailer/index.asp