I have an access form, "frmCompetition" with a subform, "sfrmDogBrace." This is a database for field trials for bird dogs. I would like to filter the contents of the subform based on selections I make in 3 separate comboboxes in the main form. Any advice? I've tried makeing the underlying query of the subform reference the contents of the 3 comboboxes as criteria. No luck. Is there some vba code I could use? My comboboxes are cboyear, cboday, and cbo brace.
As you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcactRelated and similar functions. Further, it offers better read-out of Multi-Value fields.