Button in Form to open a different form and chose a customer based on last form

[TEDOC]

Hello Guys,

Basically I have a Customer Form, which I have a New party button on it,
this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.

I have tried the GoTo macro's but cannot seem to get it to work, A little guidance and/or help on this would be greatly appreciated.

I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.

How would I go about getting this to work?Jubilee.zip

[TEDOC]

I have tried this. On the Customer Form Button,

Code:

DoCmd.OpenForm "New Party List", acNormal, "", "", , acNormal On Error Resume Next DoCmd.GoToRecord , "", acNewRec If (MacroError <> 0) Then Beep MsgBox MacroError.Description, vbOKOnly, "" End If
And this as the New Party List Form OnLoad

Code:

Me.[Name of Customer] = Forms("Customers")("Customer Name")
I get this error.

The Value you entered isn't valid for this field

[TEDOC]

Can anyone please help me with this?