Help with compile error

[ducky]

Private Sub cmdSaveChanges_Click()
'Calling Procedure
SaveChanges Forms!frmDogs
End Sub

How do I call a function and pass in the form name?
i keep getting an compile error
Wrong number if arguments or invalid property assignment

[NeoPa]

How do I call a function and pass in the form name?

I'm not sure what you're trying to do in your code, but, in answer to your question :

Variable = YourFunction(Me.Name)

[ducky]

I'm not sure what you're trying to do in your code, but, in answer to your question :

Variable = YourFunction(Me.Name)

I am trying to use this code to call a procedure and pass in the form name.
The code I had in the first message was the code attached to a button - and I need this to call the Save prodecure and pass in the name of the form as a parameter.

[NeoPa]

I assume that you're happy that this answers your question?

[MMcCarthy]

 
Private Sub cmdSaveChanges_Click()
  'Calling Procedure
  SaveChanges Me.Name
End Sub
 
 

This should do it.

Me.Name will return the name of any form you are on.