Hi There,

I could not get a commandbutton (that I titled submit survey) to send the survey to me, so what I did was record a macro and tried to execute the macro from the button, it mostly works (see code below) but I keep getting object required, but do not understand what it is looking for ... Is anybody out.... Can Anybody help me :{ ... Confused and frustrated...

Private Sub CommandButton1_Click(
On Error GoTo Err_Command1_Clic

Dim stDocName As Strin

stDocName = "SubmitSurvey
DoCmd.RunMacro stDocNam

Exit_Command1_Click
Exit Su

Err_Command1_Click
MsgBox Err.Descriptio
Resume Exit_Command1_Clic

End Sub