I just recently started using Access and can't figure out a couple of things, any help is appreciated
I am trying to filter a table using a Combo Box which then displays a subforms based on field selected in the Combo Box. But the same name appears in the combo box if its enter in the table multiply times. I tried to type distinct in the Row Source but there was no effect.
Also in the Subform I am trying to calculate the Average, which I get it to work but for some reason there's a third row added to the subform row.