Executing a Stored Procedure

[primagic]

I have the following stored procedure which executes perfectly on a click event of a button. however, when I add the code to an afterupdate event, it wont execute.

Any reason why?

Dim cmdCommand As New ADODB.Command

With cmdCommand
    .ActiveConnection = CurrentProject.Connection
    .CommandType = adCmdStoredProc
    .CommandText = "UpdateScores"

        '@intDocumentNo
        .Parameters("@StatusScore").Value = Forms!frmLeads!frmScoreSummary.Form.Text6

        '@intCustomerNo
        .Parameters("@LeadID").Value = Me![LeadID]

    .Execute

End With

 

[traingamer]

If you put a breakpoint in the code, does it actully ever get to the code itself?

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[dhookom]

afterupdate event" of what? The form or a control?

Duane
Hook'D on Access
MS Access MVP

 

[primagic]

Of a control

 

[dhookom]

Do you understand traingamer's request?

Duane
Hook'D on Access
MS Access MVP