AnsweredAssumed Answered

Date Modified + IF Statements with Dates

Question asked by JoyantoRoy on Aug 4, 2011
Latest reply on Aug 4, 2011 by philmodjunk


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.