VBA code used to work now it does not

[rachello89]

I have a button on a report that opens a form and displays the information for a specific client. Here is the code below:

Private Sub Command14_Click()
DoCmd.OpenForm "Edit Client", , , "ClientID = " & Me.ClientID
End Sub

.

It worked beautifully, but I recently put the backend on SQL Azure and still use Access for the front end. The button no longer works. You can click all you want and it is not opening that form. I don't know if the transition caused this or something else I did. If someone could point me in the right direction, that would be great. I have some users that are not happy that this does not work anymore.

[RuralGuy]

Did you put a MsgBox message in the event to make sure the Click event is executing?

[rachello89]

No I did not. I do not actually know how to do that. Could you tell me how to put that in? I am very new to VBA codes.

[RuralGuy]

Change your event code to:

Private Sub Command14_Click()
   MsgBox "About to open the 'Edit Client' form!"
   DoCmd.OpenForm "Edit Client", , , "ClientID = " & Me.ClientID
End Sub

[rachello89]

Thanks for your reply.

I typed it in just how it was written, but a message box does not even pop up. I guess that means that the event procedure isn't working. Any ideas?

[orange]

Did you do any preliminary testing as you moved the backend to SQL Azure? What did you actually do?
Do you really have a button on a Report, or is it another Form?

[John_G]

Hi -

Did you verify that the properties pane for the command button actually indicates there is a procedure associated with the On Click event? Might you have renamed to command button? If you do that, Access can no longer associate the code to the button - you have to rename the sub from Command14_Click to NewName_Click().

John

[RuralGuy]

Access 2007 also requires your system to be in a Trusted location for the code to execute.

[rachello89]

Thanks guys for your input! I had been ignoring the yellow security warning bar that is at the top when you open. When I clicked enable content, my code worked. RuralGuy's comment led me to see if that was it, and it was. Thanks for your help!

[orange]

Glad you got it working, and thanks for telling us what you did.