Greetings,
I am using Access 97 at work, Access 2000 at home. This is a work project.
I have a database that tracks employee awards. One type of award is the Peer Award. An employee can receive more than one award during the reporting period (01 May 05 through 30 April 06), but an employee can nominate someone only ONCE during this period. The query also filters all award for the word PEER in the Award_Type field.
I need a method in my subform (where all of the award info is entered) to display a message if the NOMINATED_BY field contains the name of a nominator more than once. I am using a combobox (cboNominated_By) to select the nominator from a query based on the Employee_Name table.
I had thought of making the field NO DUPLICATES, but cannot do that, as I also keep these records as multi-year archives.
In my query I have as the criteria to limit records for the reporting period above.
In my subform, is there a method to check the combobox that I'm using for a duplicate nominator, then notify the user of this duplicate?
I've seen something similar to what I want in the below thread, but FoFa didn't offer an example of how this would be accomplished;
Notification of Duplicate Records
http://www.access-programmers.co.uk/forums/showpost.php?p=158082&postcount=2
Thanks all for any assistance you might offer!
I am using Access 97 at work, Access 2000 at home. This is a work project.
I have a database that tracks employee awards. One type of award is the Peer Award. An employee can receive more than one award during the reporting period (01 May 05 through 30 April 06), but an employee can nominate someone only ONCE during this period. The query also filters all award for the word PEER in the Award_Type field.
I need a method in my subform (where all of the award info is entered) to display a message if the NOMINATED_BY field contains the name of a nominator more than once. I am using a combobox (cboNominated_By) to select the nominator from a query based on the Employee_Name table.
I had thought of making the field NO DUPLICATES, but cannot do that, as I also keep these records as multi-year archives.
In my query I have as the criteria to limit records for the reporting period above.
In my subform, is there a method to check the combobox that I'm using for a duplicate nominator, then notify the user of this duplicate?
I've seen something similar to what I want in the below thread, but FoFa didn't offer an example of how this would be accomplished;
Notification of Duplicate Records
http://www.access-programmers.co.uk/forums/showpost.php?p=158082&postcount=2
Thanks all for any assistance you might offer!