Reference to a query from a form does not work

[giladweil]

Hello,

I created an automatic pop-up form that appears when opening the database, and in it a button that refers to a query.
When I click the button appears the message -



"The expression On Click you entered as the event property setting producted the followinng error: Ambiguous name detected: YourButton_Click"

The query itself works well without the referral from the button on the form.

The VB file:

Private Sub Command2_Click ()
On Error GoTo Err_Command2_Click

Dim stDocName As String

stDocName = "LayersAll"
DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_Command2_Click:
Exit Sub

Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click

End Sub

[maximus]

Dim strDocName As String
strDocName = "Query3"
DoCmd.OpenQuery strDocName, acViewNormal, acEdit

I think it will be acViewNormal

[giladweil]

Thanks,
It still does not work. The Syntax should be fine - he worked in the past. It stopped working as soon as I transferred the file from my computer to a server, even after refreshing the links.
The queries themselves work fine - the connection with the form does not work.

[giladweil]

anyone? help?