Access Forms

[Guest]

I have a form that contains a sub-form set for continuous forms. The subform
first selects a value for a specific company. The second combo box needs to
select available items from that company, and only that company. The values
are already assigned in a table but they need to be applied to the Main
record in the primary form. I am having trouble with the second box not
recognizing the value of the first and therefore not being able to querry out
the items for that specific company.
What are my options.

 

[Rick Brandt]

I have a form that contains a sub-form set for continuous forms. The
subform first selects a value for a specific company. The second
combo box needs to select available items from that company, and only
that company. The values are already assigned in a table but they
need to be applied to the Main record in the primary form. I am
having trouble with the second box not recognizing the value of the
first and therefore not being able to querry out the items for that
specific company.
What are my options.

Fix the query. Post your SQL and someone can likely tell you what is wrong with
it. My guess would be that you are referencing the other ComboBox as if it were
on an open form, but a subform is not considered an open form. The reference
has to go via the subform control on the main form.

Forms!MainFormName!SubFormControlName.Form!ComboBoxName