Records shown in subform based on combo box selection on a main form

[vazdajic]

Hello there. I have a problem.. Picture attached says it all (DB attached as well).

I have tried as:

SELECT [WELDS].[KKS], [WELDS].[WN], [WELDS].[WS], [WELDS].[OD], [WELDS].[WT], [WELDS].[DWG], [WELDS].[DATE_WELDED], [WELDS].[NOTE]
FROM [WELDS]


WHERE (((WELDS.[KKS])=[Forms]![WELDS_INPUT]![Combo3]))

but it doesn't show me all records (WN) related to the same KKS (one to many relation; one KKS many WN) but just one row in subform containing KKS

Help much appreciated..

[Lewis825]

on the Query that runs the Subform you'll need to add critrea to the KKS field

=[form]![*FormName*]![*cmbChooseKKS*]

then add me.refresh on the after update of combobox