How to use combo box as a filter for a form?

[hagamablabla]

I'm currently making a mockup of a database that has a table of items, a table of projects, and a table of which items are used by a project. I would like to make a split form that can select a project through a combo box, find the associated project ID, then show only the items used by that project.

Also, as a side note, if anyone has moderate - advanced guides on how to make forms, preferably non-video, I'd like to see them. Every guide I've found seems to either be for beginners (ends at how to create a form), or is in a video format.

[June7]

https://support.office.com/en-us/art...8-C266FE084102

Options:

1. intrinsic search/filter tools

2. dynamic parameterized query

3. VBA code, review http://allenbrowne.com/ser-62.html

[hagamablabla]

Thank you, I will try these out. I'm having some trouble linking the combo box to the subform though. How do I do it?

[June7]

What do you mean by 'linking' - making the RowSource conditional on some other field? Known as 'cascading' or 'dependent' combobox. And exactly what is the 'trouble' - error message, wrong results, nothing happens?

[hagamablabla]

By linking, I mean making it interact with the other parts of the form. For example, I can select a project name in a combo box, but doing so doesn't change anything except the name displayed by the combo box. I'd like to be able to have that value affect other things, such as updating a filter for the subform.

[June7]

Review http://allenbrowne.com/ser-62.html