Call a button click from another form

[Rgaming]

I need code that opens a form called "Add payments". and clicks on a button called "Add_new_Payment" then closes the form.

I tried this but it doesn't work, it comes up with a syntax error




Private Sub Command51_Click()
Call Forms."Add_Payment".Add New Customer_Click
End Sub

Any help appreciated

[RuralGuy]

Have you consudered putting your OnClick code in a Standard Module so it can be called from both the "Add payments" Form and where you are currently?

[Bulzie]

What are you trying to do with what you listed above? Instead of opening a Add_Payment subform, can you just add the payment from the main form if no data entry is required? Maybe give more description and steps in your process so we can understand more what you are trying to do.

[June7]

Duplicate thread? https://www.accessforums.net/showthread.php?t=68617

Or at least a continuation of same issue. Calling a procedure is useless when the code is non-functional to begin with.

The name of your button is "Add New Customer" - with spaces? VBA will substitute with underscores in the procedure declaration. Try:

Call Forms("Add_Payment").Add_New_Customer_Click

Advise not to use spaces nor punctuation/special characters (underscore only exception) in any names.