using multiple combo boxes in one form

[quandore]

Hi everybody, this is another newbie question. please be aware that i just started using access so i do not know the basics of programming with such software.

i made a form from a "CS-PG1-PG2" table. then i added a subform that contains these 3 fields plus some more information.
What i'm trying to do is to insert in the main form 3 combo boxes:

CS (discount group): not to be linked/synchronized with the other two combos;
PG1 (product group);
PG2 (product group2): it must show the filtered results from PG1 combo box.

As long as I insert the CS combo box, everything is fine. Whenever i add the other two combo boxes, or just the PG1 combo box, then the two of them conflict and i get zero records.

All i want to do is to add these 3 combos and give an option to filter the results by CS or PG, plus give some sort of hierarchy order between the PG1 and the PG2.

Hope i managed to explain my problem and that you can help me out.

[orange]

watch the video tutorials here for ideas
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

[hertfordkc]

How is the subform linked to the main form? To the combo boxes? Maybe another way of isolating your problem is to ask: If you set aside the notion of a subform for a moment and made selections in the combo boxes, and then activated the other form, would you get the results you are expecting?

Do you have references to the main form in the subform or are you somehow depending on the parent-child link?

[quandore]

Sorry if i didn't answer your question but I suspended this project during the past week or so.

Now I'm back again. I'll try to give you more information:

How is the subform linked to the main form? To the combo boxes?
The subform is not linked now, I'm stuck. The CS combo box was linked to the subform through those parent/child things. It worked pretty smoothly. The problem arise when I added the PG1 and PG2 combo boxes. Then everything stopped working.

I will also explain you how is the DB structured:

Tables:
MainTable IT: big tables with all the information regarding the Italian market
MainTable GR: same as before, but for the Greek market
Cs-PgTable: a table that includes all the CS's and PG's that I use for my combo boxes.

Forms:
MainForm: takes data from the Cs-PgTable
SubForm IT: takes data from the MainTable IT
SubForm GR: takes data from the MainTable GR

Note that these two subforms can be selected one at a time by just choosing page 1 or 2 in the main form.

I need your help...

PS
I'm pretty sure this all wrong, but hey, I've never done it before

[quandore]

any help would be much appreciated

btw I managed to synchronize the PG1 and PG2 combo boxes. I used this code.

Private Sub PG1description_AfterUpdate()
Me.PG2description.Requery
Me.PG2description = Me.PG2description.ItemData(0)
End Sub

and i added a WHERE criteria in the pg2description combo box.

so good so far. but i still need to add the CS combo box without messing everything out!

[quandore]

Hello... last UP to see if anyone here can try to help me out :-)

I don't know how to link an unbound combo box to a subform which has been added to display filtered data in a main form. This is the main problem. The only way i know to achieve that, is by creating a master-child relationship in the subform properties. My problem is, this way i can only add a combo box at a time. Can't manage to have multiple combo boxes related to the same subform.