Hide duplicate records in subform

[Greyowlsl]

Hi,
Ok so I have a subform where some records are shown twice, but not duplicated in the actual table source. I was wondering if there was a some way i could use vb code to hide any duplicated records that have the same 'Document Number' as the original.

Thanks for reading, i would be very greatfull for any help.

 

[gemma-the-husky]

check your query for the subform

right click in a blank area of the table area, and select properties. there is a setting for "output unique values only" which will exclude duplicates, but will also probably make the query non-updateable.

if you are getting duplicates there must be some reason for that however, and the above example will randomly exclude the duplicates.

 

[Greyowlsl]

Hi,

Yea i have tried that but it says the OLE doesnt work for hyperlinks, and i hayperlinks. Also the data does need to be editable. The edit log subform is what is causing the problem in the first place becuause im trying to have more than one edit records for only one document record (1 to Many relationship) when i do this more of the exact same records appear in the document subform.


Thanks for you help

,leon