Update Subform info when Main form Combobox changes

[sbehera]

Hi,

I am a new to MS access and working on a simple thing which I am not able to do despite of many examples seen over internet. I want to update the Subform data when the combobox is changed.

Main form Name: QryForm
Subform Name: QryTask subform
Query Name: QryTask

Can anyone please help. Attached is the sample DB. If any can update the attached file along with the help, it would be greatly appreciated.

Thanks a lot in advance.



Regards,
sbehera

[breakingme10]

You have done no actual work to attempt to make the form work. There is no VB code or macros. You need to at least try and do it before just asking someone else to do it for you.

[sbehera]

hi,
Yes i have worked on it, but all have failed. that's why i have uploaded a clean one. I have tried with master Link, Child Link, form!control and also few codes. For Codes I am not so fluent as in excel. I have seen at least 4-5 videos on youtube and atleast 20 to 25 examples for the same. bur all are either too complicated to understand(for me) or its giving me errors. I always try to do it myself and if not able to do then go for help. If somebody can instruct me how to do that, even give some link(similar to this, not so complicated, i have gone through many search), i will try it again, meanwhile also I am trying.
anyway thanks for your attention.

[sbehera]

After a long time of trial and error I am able to link. I have linked Main form with subform through Link Master fields/Link Child Fields.
However one demerit of this method is it shows the result when all combobox are selected. What I want is if one of them is blank, then the result should be with all the rest combobox selected. I hope that make sense.

Attached. Meanwhile my try continues....