I'm a complete newbie to error handling. In a form I have a ComboBox that is tied to a table with a relationship of One to One, Indexed and No Duplicates.
When I select from the ComboBox an item that already exists in another record and try to save I get an error, '3022', which is fine but I want to be able to show a message box stating they can't use the selection because duplicates are not allowed. They could just select OK and pick another item.
Where do I put the Error Handler and what would the VBA look like? Thanks.