Combo Boxes in subforms in Main forms Won't Work

  • Thread starter Thread starter ddw_23
  • Start date Start date
D

ddw_23

hi Everyone!
I have a customer database in Access 2003. There are 2 forms that I
will briefly explain.

Form 1: Student's Information
Has 2 combo boxes (1 for "Division"; 1 for "Program")
The Program combo box selections is based on the selection of Division
combo box
This form works fine...it's a basic form

Form 2: Employers
Same combo boxes but titled: (1 for "Industry"; 1 for
"Department")
This form has several sub-forms. Only one sub-form has the same combo
boxes as form 1.
The combo boxes work fine in the sub-form alone. However, when placed
in the main form (Employer) and I execute the main form, I get the
following message box appears:

"Enter Parameter Value"
Forms!frmJob Order Form!Industry

This is the query that is in the RowSource property control of
"Department"

And once I open the form "Employer", my combo boxes won't work.
When I make a selection in the "Industry" filed, the same "Enter
Parameter Value" box appears.

Where "frmJob Order Form" is the sub-form that contains the combo
boxes.

Will someone pleeeeeease tell me what I need to do to solve this
problem? As I stated, it works fine until it's within a main form.
ANY and ALL guidance is appreciated!
I will be happy to supply the DB upon request.
 
Subforms are not open on their own when they're subforms. Your reference to
the combo box must be qualified by the main form's name, and you must use
the name of the subform control (the control that holds the subform in the
main form) as well:

Forms!MainFormName!SubformName!ComboBoxNameOnSubform

where SubformName is the name of the subform control.
 
Back
Top