'Filtering microsoft access records based on a combo box

I have a Microsoft Access database. It has a LOOP Table . I also have a form which includes all Loops and their info.

I want to make a combo box (drop down box) that would include the subsystem . When the user chooses a subsystem from the combo box, only the records which were added in that subsystem will show up in the records table.

Can this be done? I have been trying to do this for at least 5 days but no luck..

Kind regards.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source