Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Emailing Form Input

Status
Not open for further replies.

NebraskaGod

Technical User
Apr 12, 2001
9
US
I would like to set up a command button that would email the information just inputted to a form. Any ideas?
 
The way I did it was to set up a report that had all the information for the form on it the sent the rpt via e-mail. The only thing you would need to put on the e-mail who you were sending it to. Here is a sample of the code to SendObject.

Private Sub cmdDate_Click()
Dim stDocName As String

stDocName = "LaidLaw Date Report"
DoCmd.SendObject acReport, stDocName

End Sub

Try and and see if this works for you.

:)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top