Date Modified + IF Statements with Dates
I programmed a database and am running into difficulty coding an IF statement that notifies the user when they are writing over an exisiting record.
Statement of Problem: Users of database are writing over pre-existing records.
Solution: Use an IF + Date statement that pops-up when a user is about to change a record with an earlier date stamp. Give the user to continue editing record or create a new record.
I am not sure if this is the best way to attack the problem. Any suggestions are welcomed.