Sub Forms and Combo Boxes

[Guest]

I have a main form for time entry that also includes a sub form where the
user can choose a category and a subcategory in which to record their time.
The sub form's subcategory combo box is based on the category combo box.
When I open the sub form only, everything works great. When I open the main
form on which the sub form resides, I am prompted for data much like a
parameter query. The prompt is the same as the criteria on my subcategory
combo box's Row Source query.

Forms!frmTimeEntryDetail!Category

What am I doing wrong?

Thanks.

Melinda

 

[Michel Walsh]

Hi,

When referring to a control in a form-subform structure, you have to know
where is the control (in the form, or in the subform) and WHERE IS THE
running CODE (in the form, or in the subform, or elsewhere). See
http://www.mvps.org/access/forms/frm0031.htm for a nice tabular presentation
of the possible cases.


Hoping it may help,
Vanderghast, Access MVP