ComboBox Problem- Try again

[jdk]

I have a main form where a students name is selected. After selected the
name- the subform populates all criteria related to the students program. I
have 3 combo boxes (Which choose a subject area- then a subheading under the
subject) in the subform that determine the data in the third combobox
listing.
The problem is that if I run the subform by itself, the combobox shows the
exact data that I want. However when I run the main form, I get an "Enter
Parameter Value" when a student is selected if data already exists in the
first two comboboxes.
If both combo boxes are blank- the message appears after clicking on the 2nd
combo box (strand)- requesting (Enter Parameter Value msg)
"Form!Fm_InputGoal!cboSubject". After entering data, and selecting an item
both Fm_InputGoal!cboSubject" and "Form!FmInputGoals!cboStrand" msgs pop
up. If I enter the parameters with appropriate data, all works well. But
that defeats the purpose of the comboboxes.

Any ideas of what is going on here?

[jdk]

Figure it out

The error occurred in the SQL statement

SELECT [Field 1] From [Table name] Where ([Field1] =
[Forms!]!Subformname]![Combobox Name]...........

It works by deleting the [Forms!]!Subformname]![ ..........] and simply
leaving the Combobox name after the =s.

Thanks to all who looked at this.

Joe

"jdk" <tr*****@hotmail.com> wrote in message
news:Su*******************@fe3.columbus.rr.com...

I have a main form where a students name is selected. After selected the
name- the subform populates all criteria related to the students program. I have 3 combo boxes (Which choose a subject area- then a subheading under the subject) in the subform that determine the data in the third combobox
listing.
The problem is that if I run the subform by itself, the combobox shows the
exact data that I want. However when I run the main form, I get an "Enter Parameter Value" when a student is selected if data already exists in the
first two comboboxes.
If both combo boxes are blank- the message appears after clicking on the 2nd combo box (strand)- requesting (Enter Parameter Value msg)
"Form!Fm_InputGoal!cboSubject". After entering data, and selecting an item both Fm_InputGoal!cboSubject" and "Form!FmInputGoals!cboStrand" msgs pop
up. If I enter the parameters with appropriate data, all works well. But
that defeats the purpose of the comboboxes.

Any ideas of what is going on here?