ComboBox Problem- Try again

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?

re: ComboBox Problem- Try again

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" <trufitt@hotmail.com> wrote in message
news:SuBub.22283$kL2.18942@fe3.columbus.rr.com...[color=blue]
> 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.[/color]
I[color=blue]
> have 3 combo boxes (Which choose a subject area- then a subheading under[/color]
the[color=blue]
> 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[/color]
"Enter[color=blue]
> 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[/color]
2nd[color=blue]
> combo box (strand)- requesting (Enter Parameter Value msg)
> "Form!Fm_InputGoal!cboSubject". After entering data, and selecting an[/color]
item[color=blue]
> 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?
>
>
>
>[/color]