Hi there Everyone! Althought I still did not get any answer to my previous question (post: http://www.access-programmers.co.uk/forums/showthread.php?t=212420) I am already having another problem.
I have a list from which I can select the records. With the help of the VBA the fields fields on the form populate different data belonging to that record.
My problem is when there are multiple data belonging to the same record. Please see the file attached. I have three tables: Risk, Assessment and Controls. There is a list box on the left which contains the risks. When I click on one of the risks the Assessment tab displays the impact and likelihood amounts belonging to that record (VBA code). But one risk can have many controls. And here is my problem. On the Controls tab I have a query displayed which shows the control points. This subform shows all the Controls, however I would like to show only those which are belonging to the selected risk on the listbox. How could I do that?
Thank you in advance and have a nice weekend.
I have a list from which I can select the records. With the help of the VBA the fields fields on the form populate different data belonging to that record.
My problem is when there are multiple data belonging to the same record. Please see the file attached. I have three tables: Risk, Assessment and Controls. There is a list box on the left which contains the risks. When I click on one of the risks the Assessment tab displays the impact and likelihood amounts belonging to that record (VBA code). But one risk can have many controls. And here is my problem. On the Controls tab I have a query displayed which shows the control points. This subform shows all the Controls, however I would like to show only those which are belonging to the selected risk on the listbox. How could I do that?
Thank you in advance and have a nice weekend.