Filtering Subform CBO based on Main Form CBO state

[vazdajic]

Hi everyone.

I need some help to filter CBO on a Subform, based on Main Form CBO state.



Below, I have attached a printscreen of the challenge I have and DB in ZIP format.

Any help/suggestion is welcome.

Thanks everyone.



WWV_Calculations_04.07.2021-07.zip

[Welshgasman]

Change the rowsource of the combo in the afterupdate event of that control in the main form.?
https://docs.microsoft.com/en-us/off...obox.rowsource

[orange]

This sql will restrict the combo Description to those records where
the subform Kataloge_Name = the KatalogName in the parent form

(tbl_Alle_Kataloge.Katalog_Name)=[Forms]![frm_Arb_Paket].[Katalogname])


Modify the rowsource of the combo to

SELECT tbl_Alle_Kataloge.AlleKatalogeID, tbl_Alle_Kataloge.GroupID
, tbl_Alle_Kataloge.Description, tbl_Alle_Kataloge.Unit_Time
, tbl_Alle_Kataloge.Size, tbl_Alle_Kataloge.Unit, tbl_Alle_Kataloge.Katalog_Name
FROM tbl_Alle_Kataloge
WHERE 
(((tbl_Alle_Kataloge.GroupID)=[Forms]![frm_Arb_Paket]![subform_Kalkulationen]![GroupID]) 
AND 
((tbl_Alle_Kataloge.Katalog_Name)=[Forms]![frm_Arb_Paket].[Katalogname]));

[mike60smart]

Hi
Change the Row Source for the Description Combobox to this:-

SELECT tbl_Alle_Kataloge.AlleKatalogeID, tbl_Alle_Kataloge.GroupID, tbl_Alle_Kataloge.Description, tbl_Alle_Kataloge.Unit_Time, tbl_Alle_Kataloge.Size, tbl_Alle_Kataloge.Unit, tbl_Alle_Kataloge.Katalog_Name
FROM tbl_Alle_Kataloge
WHERE (((tbl_Alle_Kataloge.GroupID)=[Forms]![frm_Arb_Paket]![subform_Kalkulationen]![GroupID]) AND ((tbl_Alle_Kataloge.Katalog_Name)=[Parent]![KatalogName]));

Sorry Orange has provided the same answer as me

[vazdajic]

Hi Mike.. Thank you so much..

Although, Orange has provided the same (as you say), this is what I wanted.. As I am novice here, I'm pretty sure I would have messed something up while applying the instructions Orange has provided LOL.. Luckily, dummies like me have guys like you to help.