msg box for unwanted duplicates

[Bill Neilsen]

Hi Guys I have a table of employment positions with a field called [Employee]
I have the field index set as "Yes (No Duplicates)" so that only one
employee can be allocated to a position.
If the user (when using the input form) selects an employee that is alocated
to another position is it possible to have a simple message box to inform the
user e.g "This employee is already alocated to another position"

 

[Bill Neilsen]

Thanks Bonnie, it works very well. How simple some solutions can be.
I appreciate your help mate.

Hi Bill,

If you are receiving a standard error message when the user tried to add the
employee, change it to your own custom message. Here's a link with
instructions:

http://www.databasedev.co.uk/custom-error-message.html

Bonnie
http://www.dataplus-svc.com

Hi Guys I have a table of employment positions with a field called [Employee]
I have the field index set as "Yes (No Duplicates)" so that only one
employee can be allocated to a position.
If the user (when using the input form) selects an employee that is alocated
to another position is it possible to have a simple message box to inform the
user e.g "This employee is already alocated to another position"