overwriting rows in a table

V

VickyC

Joined
Sep 23, 2010
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append records to table only if user selects "True" on form 2
Using Code to test if a value is in a list 4
Regarding data entry in the form of a date into a textbox and using it to search for a record. 1
Data entry for a table from a form 1
New rows overwriting existing problem 1
Make Field Enterable 1
How to undo saving a new record? 2
Sort rows in a sub-form 4

Top