Microsoft KB Archive/119475

= ACC2: Command Button Wizard Prompts for Parameter Value =

Article ID: 119475

Article Last Modified on 8/20/2001

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q119475





SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.

When you choose a command button, created with the Command Button Wizard, on a subform to open another form to the current record in the subform, you are prompted "Enter a parameter value" for the value of the linked field as if the subform were a main form, not a subform.



CAUSE
When you created the command button, the Command Button Wizard did not recognize that the form you were using was a subform. Instead, the wizard assumed that the form was a main form.



RESOLUTION
After you run the Command Button Wizard, edit the command button's code to properly reference the control on the subform. The correct syntax for referencing a control on a subform is:

  Forms![MainFormName]![SubformName].Form![ControlName]



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.



Steps to Reproduce Problem
CAUTION: Following the steps in this example will modify the sample database NWIND.MDB. You may want to back up the NWIND.MDB file, or perform these steps on a copy of the NWIND database.


 * 1) Open the sample database NWIND.MDB.
 * 2) Open the Categories Subform form in Design view.
 * 3) Set the form's DefaultView property to Single Form.
 * 4) Make sure that the Control Wizards button in the toolbox is selected (the button should appear sunken).
 * 5) Add a command button to the form. Fill out the Command Button Wizard screens as follows:


 * 1) In the Categories box, select Form Operations. In the When Button Is Pressed box, select Open Form. Choose the Next button.
 * 2) In the "What form would you like this command button to open?" box, select Products. Choose Next.
 * 3) Select the "Open the form and find specific data to display in it" option button. Choose Next.
 * 4) In the Categories Subform box, select Product ID. In the Products box, select Product ID. Choose the "<->" button, then choose the Finish button.
 * 5) Save and then close the form.
 * 6) Open the Categories form in Form view.
 * 7) Choose the new command button on the subform. You will be prompted:

Enter Parameter Value: Forms!Categories Subform!Product ID

