We’re using a single table to record daily data – the date field is set as the pk so only one record per date is allowed.
If the user enters a date (when creating a new record) that already exists in the table
what is the best way to;
a) avoid the Access error message about duplicate values,
and
b) allows the user to enter an alternative date for the new record?