I'm building an MS Access 2010 database that includes several many-to-many relationships. For data entry, I would like to try a tagging-style interface (like the "Tags" field on this post!) instead of the usual multi-row subform. I've built databases using subforms and combo boxes for many-to-many relationships before, but they're clunky and keyboard navigation is difficult.
Is there any way to make this happen without writing a thousand lines of VisualBasic?
A decent explanation of the subform-and-combo-box method is here