Subform control asking for parameter vaue. Please help.

[mgforbes]

Hi guys first post and hoping for some assistance.



I have a form control (combobox) which displays a list of complaint categorys called [CorrectComplaintCategory] in a form called [QAInput Subform] and another combobox within the same form called [CorrectComplaintCode]

[CorrectComplaintCategory] has a macro to requery the [CorrectComplaintCode] after update and [CorrectComplaintCode] has the following rowsource:

Select distinct raw.rng_cc
From raw
Where (((raw.rng_cc)<>"Not Found") and ((raw.primary_complaint_tier5_=[forms]![qainput subform]![correctcomplaintcategory]))
Order by raw.rng_cc;

This works fine when I have the form open directly, however, if I am using the form as per its intended use (As a subform) then when I select the combobox it asks for the parameter value for [CorrectComplaintCategory] if I manually type in an expected result then it will work.

My question is how do I get the reference to work when in a subform environment. (The main form is called [Form_Filters])

Thanks in advance

[June7]

Give the combobox a name different from the field it is bound to, like: cbxCategory
Drop the form name qualifier.

Select distinct raw.rng_cc
From raw
Where (((raw.rng_cc)<>"Not Found") and ((raw.primary_complaint_tier5_=[cbxCategory]))
Order by raw.rng_cc;

[mgforbes]

Hi June

Thanks for the prompt response. That's worked perfectly, thanks very much.