Hide Duplicate in Form

[ser004]

Hi all,

I have an Access DB displaying stats on NHL Hockey Players. I have a Form with a subForm - what I like to do is hide duplicate detail data in the subForm. Example:

Year Ligue Team GP G A TP
1998-99 NHL Chicago 62 45 20 65
1998-99 NHL Boston 20 15 12 27

Under (Year) I would like to hide the duplicate year on my form. For a Report it is very easy - you just select "hide duplicate" under field property. But for a FORM how this is done since the "hide duplicate" option is not there.... My forms are linked with Master / Child with a PlayerNo field...

Thanks in advance...

 

[John Big Booty]

This thread may help.