Passing Values from One Form to Another Form - Enter Parameter Value Issue

[nika.duncan]

Hi Everyone,
I have a form called Customer and a subform called CustomerDetail. Once I click on the button "Open Form" on the CustomerDetail form I want to be able to see only the transactions for that customer. I used the embedded macro below to pass the data.

"[CustomerDetail]![CustomerDetailID]=[TransactionDetail]![Cust_DetailID]"

When I clicked on the button I receive the message "Enter Parameter Value" once I enter the "CustomerDetailID" the transaction details will be listed. I need the form to be open without the message and the transaction details listed.

Any assistance in removing this message will be appreciated. I have included the database "Cambio3.zip as well.

Thanks,
Nika

[aytee111]

I'm not sure where exactly this macro is situated in your database. Try adding [Forms]! in front of both form names above.

[nika.duncan]

The macro is on the Open Form Button that is situated on the CustomerDetail form on the On Click property. I have added the [Forms]! before both forms and I still receive the error shown below. This time it does not pass the value.



Thanks
Nika

[John_G]

When you use a form as a subform, it does not become a part of the Forms! collection, so in the macro expression:

"[CustomerDetail]![CustomerDetailID]=[TransactionDetail]![Cust_DetailID]",

[CustomerDetail]! does not refer to an open form (it's a subform) so you get prompted to enter for a value.

I hate macros with a passion (!) so in the CustomerDetail Subform I replaced the macro with an Event procedure:

Private Sub cmdTransction_Click()
  DoCmd.OpenForm "transactionDetail", , , "Cust_DetailID = " & Me!CustomerDetailID
End Sub

and it worked fine.

Notice the use of Me! in the DoCmd - Me! will always refer to the form where it is used, even when it is a subform.

[aytee111]

Put this in the Filter (not the Where) : Cust_DetailID=forms!customer![customerdetail subform!CustomerDetailID

[John_G]

Not quite the right syntax for the filter:

Cust_DetailID=forms!customer![customerdetail subform].form!CustomerDetailID

A subform is not usually referred to by the form name in a context such as this.