How to get Filters to work on SubForm

[Kharonne]

Hey Guys,

I really need some help, so I am posting this question again but phrasing it another way.

I have a subform that is linked to the main form through the link field "ProjectNumber". However, I need the subform to filter records on that linked field. I cannot seem to get it to work. Has anyone been able to filter on a subform whose linked field has many records?

 

[boblarson]

If your master / child links are set properly the subform will only display records that are associated with the main form via the linked field. So, if it isn't working then you probably either don't have your links set properly OR you are including the table from the main form in your subform's query (which is a very common mistake people make). If you have that table in your subform's query then remove it. You shouldn't have it there.

 

[Kharonne]

Hey Bob,

I just wrote the form another way based on a query. It just seemed too hard for me to get the filters to work the way I imagined. Plus, I was having a really hard time articulating my issue with the form and filters. Thanks for your help.