I have a form (information) and subform (categories for information).
The Information record can be have multiple categories assigned to it.
The problem is that if, for example, there are 3 categories assigned to the information record, the record count will count each instance of the category and show "1 of 3" for the form when it should be "1 of 1" with 3 categories on the subform.
Scrolling through the 3 records will display the same record 3 times.
Is there a way in VBA to make the form only show unique instances of information rather than an instance multiplied by the number of categories?