A
Alicia
Not sure if there is an easier way, but here goes.
Start by not having the form controls bound to the table.
When the controls are filled in by the user, in your code
do a dlookup to see if the record is already in the
table. If the record is there alert the user with your
message box, otherwise use a runSQL append to add the new
record to the table.
Start by not having the form controls bound to the table.
When the controls are filled in by the user, in your code
do a dlookup to see if the record is already in the
table. If the record is there alert the user with your
message box, otherwise use a runSQL append to add the new
record to the table.