I have a form with 2 listboxes side by side. By double clicking a record in the
first lb that record appears in the 2nd lb by way of a table. The record id
field in the table is set to no duplicates to prevent the same record being sent
twice.
If a duplicate is selected the access error box "Can not append all records in
append query etc etc" tend s to confuse users.
How to I trap this error and put up a message box which the user can understand
?
TIA
David B
Hexham UK