Search results

Thank you; I looked at it before I posted my query. I have tabbed subforms (similar to those in the example) working very well -- and can solve this problem short-term with a similar sub-form. However, as this data is updated relatively infrequently, and there are a lot of other sub-forms that...

Thanks for that, but it wouldn't let me have the many-to-many relationship I need.

The answer to this will probably be blindingly obvious... once somebody points it out to me!:o Using Access 2007, I have 3 tables: tblResearch -- primary key ResearchID plus various other fields tblTags -- primary key TagID plus one text field Tag tbljctResearchTags -- primary key plus two...