On Thu, 11 Feb 2010 09:21:24 GMT, "TonyWilliams via AccessMonster.com"
u56994@uwe wrote:

Thanks John and Steve for those suggestions. I think I understand the concept,
I've just done something similar for another of my posts. However, Steve, how
would I create a query that shows all 7 categories on a form when I'm only
holding one value?

You'ld use a Continuous Subform.

It might be necessary to base it on a Query joining the seven-row categories
table to the junction table using a Left Outer Join to show the category even
if that category has not been picked.
--

John W. Vinson [MVP]