On one of my form I have a list box that is filtered, is it possible to prevent new record from being added if the record would create a duplicate in the list box? one option is to index this field however this then applies to the entire database. I would like it to be for the filtered data only.