overwriting table rows

[VickyC]

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

[weekend00]

check them in after_update events of both monthID and testID.

[VickyC]

Thanks Weekend00 - but that's where I'm having trouble writing the code. (how to check, and then a) write new entry if the PK doesn't already exist, or b) give the user the option to either bale or to overwrite the row if the PK already does exist.)

I'm very new to this, so I need it 'spelled out' a bit

much thanks
VickyC