Novice Question On Subform

[Guest]

I need help and am inexperienced. I want to do a workout database and have
the basic setup (based on the downloaded template on the website). The
problem is this:

When I open the workout form, I have a subform (Bound Combo Form, which I
downloaded in the sample area). This subform has the two combo boxes
(category and exercise) where when you select a category (e.g. Calves) it
filters the excercise combo to show only those excercises related to the
calves. This works fine when you open the subform as a stand alone. The
problem comes up when I put it into the form Workouts as a subform. When I
open Workouts form, it pops up with Enter a Parameter Value box looking for
[Forms]![Bound Combo Form]![Category] --- which I used in the Bound Combo
Form to bind the exercise combo to the category combo.

What am I doing wrong?

 

[tomanddani via AccessMonster.com]

Mark,
Open your main form and click on the suform ( not in the subform but on the
subform control), open properties, and click the data tab. Check the Master
and Child fields. They should be set to the linking field.
Tom

I need help and am inexperienced. I want to do a workout database and have
the basic setup (based on the downloaded template on the website). The
problem is this:

When I open the workout form, I have a subform (Bound Combo Form, which I
downloaded in the sample area). This subform has the two combo boxes
(category and exercise) where when you select a category (e.g. Calves) it
filters the excercise combo to show only those excercises related to the
calves. This works fine when you open the subform as a stand alone. The
problem comes up when I put it into the form Workouts as a subform. When I
open Workouts form, it pops up with Enter a Parameter Value box looking for
[Forms]![Bound Combo Form]![Category] --- which I used in the Bound Combo
Form to bind the exercise combo to the category combo.

What am I doing wrong?