Append Query - My Own Message

[HD20]

Hello-

I have an append query and rather than the defined error message that pops up when you are trying to append a record that is already in there, I want to put in my own message.

Can anybody help me with this?

Thanks.

 

[KenHigg]

You may want to use a dlookup() to see if the record appears first, then you could use your own message...

Ken