You can create a report to minic the form(copy the fields over if needed) and for the RecordSource of the report, make it a query where you only show...
It's not looking great to me. Aside from the fact that I don't see a tblCommunity_Consensus, I see tables with PK fields and no foreign key for them...
I've created a number of databases for my personal use over the past three decades, mostly in mdb format, some converted to accdb as needed. The one...