msg box for unwanted duplicates

  • Thread starter Thread starter Bill Neilsen
  • Start date Start date
B

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"
 
Thanks Bonnie, it works very well. How simple some solutions can be.
I appreciate your help mate.

bhicks11 via AccessMonster.com said:
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

Bill said:
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"
Click to expand...
Click to expand...
 
Back
Top