I have a form with a list box. Double clicking a record sends that recordno to
a table. I have the table set to no duplicates to prevent the same record
being sent twice. If a duplicate is sent the confusing (for the user) standard
access message appears - Access can`t append all records in the append query
etc etc.

How do I make a clearer error message for this situation ?
TIA
David b

David B wrote:
Why don't you check for the existence of the record in the dblClick
event before appending it?

Look at the OnError event for the form to present your own message if
you can't trap it with an error event handler from the OnDoubleClick
event of the listbox.

Patrick Finucane <finucanp (AT) mindspring (DOT) com> wrote

What is the best way of comparing what has been double clicked with what is
already in the table ?
David B

David B wrote:
I would take the value of the listbox. For ex, if the first column
(hidden) is the key, store it to a variable. Then either open up a
recordset and look for the key or whatever column data exists or create
a Query and open that up as a recordset and see if there are any records
(recordcount > 0) or something like that.

Look at OpenRecordset, RecordCount, FindFirst (and expecially the code
examples) for more information.

If you aren't a programmer, then I would check out Dlookup and DCount in
help and any examples of code.