NEW USER! - I have a table (tblDateTestScore) with 3 columns: MonthID (date) , TestID (text) , Score (integer). The 1st TWO columns form the primary key. Sample values look like...
MonthID TestID Score
Sep, 2010 C6 82
Sep, 2010 A17 69
Sep, 2010 G3 75 etc...
Users enter these values from a form, which are then written into the table.
Here's my question: If the user now enters Sep, 2010 C6 81, I get a primary key violation. What I'd like is for a message box to warn the user that "A Score already exists for Sep, 2010 C6. Do you wish to replace this Score?"
I need help with how this can be coded.
much thanks
VickyC
MonthID TestID Score
Sep, 2010 C6 82
Sep, 2010 A17 69
Sep, 2010 G3 75 etc...
Users enter these values from a form, which are then written into the table.
Here's my question: If the user now enters Sep, 2010 C6 81, I get a primary key violation. What I'd like is for a message box to warn the user that "A Score already exists for Sep, 2010 C6. Do you wish to replace this Score?"
I need help with how this can be coded.
much thanks
VickyC