detecting duplicates in child form

[Benj]

Is there a code to detect duplicates in child form? the duplicate is not on one field only, it should be on two fields like:

DATE ITEM
june 2 apple
june 3 apple
june 2 apple
june 3 orange

it would detect the 3rd record as duplicate from the first record.



hope this is clear. thanks so much!

[isladogs]

Forms display data which is stored in tables.
You can use the query wizard to create a duplicates query for the table that contains the data you listed.