Combo Box Error in Row Source

[Proaccesspro]

I have a subform with 2 drop down boxes. The choices in the 2nd drop down box depend on the value of the first . When I run the subform on its own, it all works beautifully. However, when the I run the main form that calls the subform, I get a one of those parameter input required messages. As Greg Brady would say, "what gives"? Here is the code (query) from the subform:

SELECT SecondaryDisord er.[Secondary Disorder]
FROM SecondaryDisord er
WHERE (((SecondaryDis order.[Primary Disorder])=[forms]![case subform]![combo86]));

[Rabbit]

I have a subform with 2 drop down boxes. The choices in the 2nd drop down box depend on the value of the first . When I run the subform on its own, it all works beautifully. However, when the I run the main form that calls the subform, I get a one of those parameter input required messages. As Greg Brady would say, "what gives"? Here is the code (query) from the subform:

SELECT SecondaryDisord er.[Secondary Disorder]
FROM SecondaryDisord er
WHERE (((SecondaryDis order.[Primary Disorder])=[forms]![case subform]![combo86]));

The syntax to refer something on a subform is Forms!SubformCo ntrol.Form.Cont rol

[Proaccesspro]

The syntax to refer something on a subform is Forms!SubformCo ntrol.Form.Cont rol

I updated the SQL on the subform......sa me error!!!

SELECT SecondaryDisord er.[Secondary Disorder]
FROM SecondaryDisord er
WHERE (((SecondaryDis order.[Primary Disorder])=[forms]![SubformControl].[case subform].[combo86]));

[Rabbit]

I updated the SQL on the subform......sa me error!!!

SELECT SecondaryDisord er.[Secondary Disorder]
FROM SecondaryDisord er
WHERE (((SecondaryDis order.[Primary Disorder])=[forms]![SubformControl].[case subform].[combo86]));

[case subform] is the subform control.
Form stays as is.

I should've been more clear.

[Forms]![case subform].Form.[combo86]

[Proaccesspro]

[case subform] is the subform control.
Form stays as is.

I should've been more clear.

[Forms]![case subform].Form.[combo86]

I'm still confused......I n your example, what goes in place of the word Form? Would it be the the Main form??

In my DB, Main Form is the Main form and Case Subform is the subform.

[Rabbit]

I'm still confused......I n your example, what goes in place of the word Form? Would it be the the Main form??

In my DB, Main Form is the Main form and Case Subform is the subform.

Nothing would go in Form. Form stays as is.

[FishVal]

Hi!

It's very simple.
When you open form as subform, it will not be added to collection 'Forms".
So referencing like "Forms!frmSubFo rm.Controls!ctr Name" will return value when frmName is open as independant form.
If it is open as subform the valid reference will be "Forms!frmMainF orm.Controls!fr mSubForm.Form!C ontrols!ctrName ".

[Proaccesspro]

Nothing would go in Form. Form stays as is.

Well....Access put brackets around FORM, but it still does not work. Here is the code in the query:

[Forms]![case subform].[Form].[combo86]

[Rabbit]

Are you trying to do this from the after update event of the combobox? Because that's where you have to do it from.

You can't just set the control source of the combobox to that SQL statement because it will never update.

And you said the "code (query) from the subform", I assume this is in reference to the row source of the combo box.

[Proaccesspro]

Hi!

It's very simple.
When you open form as subform, it will not be added to collection 'Forms".
So referencing like "Forms!frmSubFo rm.Controls!ctr Name" will return value when frmName is open as independant form.
If it is open as subform the valid reference will be "Forms!frmMainF orm.Controls!fr mSubForm.Form!C ontrols!ctrName ".

Where would I place this code??