Combo boxes dependent on other combo boxes

[NateDogg]

This is what I am using to filter my combo box based on what is selected in the previous box.

Open the properties for the second combo box. Next to the 'Row Source' property, click on the '...'.

This opens the query related to the combo box.

In the criteria row under the category field, type the following:

[Forms]![Form1]![Combo1]

Where Form1 is the name of the form containing the combo boxes.

And, Combo1 is the name of the first combo box you have just made.

Change these names to suit your own database.

Close and save the query.

What I have is a main form and on this form, I have a subform. If I use the above...[Forms]![Subform]![Combo37] and try this from the subform, it works as expected. But, if I open the main form and try to use it, soon as I click on the second combo box I get a popup box stating "Enter Parameter Value" and it lists [Forms]![Subform]![Combo37]. How do I get this to work on my main form?

[Rabbit]

To refer to a control on a subform you have to use:

[Forms]![Main Form]![Sub Form Control].Form.[Control Name]

[NateDogg]

I am still getting the same results. What part of this code do i have to change to the subform name?

[Rabbit]

Let's make this clear.

On a form there are controls.
One such control is a subform object.
This object has a name and links another form that already exists.
This other form also has a name.
The name of the other form and the name of the subform object can be different.

So you want to use the subform control name and not the name of the other form when you're trying to refer to a control on a subform from the main form.

[NateDogg]

Ok, thanks. That did make it a lot clearer. I was having trouble with the [Sub Form Control]. It works now.

[Rabbit]

Good Luck.