Open form from another form

[jsic1210]

Hello everyone, I'm trying to open one form from another. The problem is, from the first form, frmCustomer, I am creating a new record. When I click the button, the new form, frmContractsForm, opens, but to a new record. Since the parent form of frmContractsForm, I want it to open based on its primary key, CustomerID. Here is my code:

'Create Open Item for New Customer
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenForm "frmContractForm", , , "CustomerID=" & Me.CustomerID

I know it's a new record in frmCustomer, but I thought the acCmdSaveRecord would solve that problem. Thanks in advance!

 

[PNGBill]

Try doing a Requiry, on first form, before you open the new form.

 

[Simon_MT]

Try saving the record and then next Form.

Simon

 

[jsic1210]

@Simon_MT: Is there a better way to save it than
DoCmd.RunCommand acCmdSaveRecord?

@PNGBill: When I requery, it opens a different record. Here is my code:
DoCmd.RunCommand acCmdSaveRecord
Me.Requery
DoCmd.OpenForm "frmContractForm", , , "CustomerID=" & Me.CustomerID

Thanks!

 

[PNGBill]

Check the Link Master Child properties and also the Add New Record properties of your new form to open.

You can set a form to open expecting a new record to be added which may be the setting you have.

 

[jsic1210]

Okay, for some reason, my code seems to be working now. I swear I tried this before:

Private Sub btnOpenItem_Click()
        DoCmd.RunCommand acCmdSaveRecord
        DoCmd.OpenForm "frmContractForm", , , "CustomerID=" & Me.CustomerID
End Sub

Thanks for the help!