msg box on duplicate entry

[janith]

Hi

I've a form which captures data from user. I want to ensure that when the first field PID is entered it should check for duplicate data in that table and immediately throw a mesg confirming that this data is duplicate . Please assist. thank you in advance....

 

[cookiegary01]

In the table design view select " Indexed" Yes (No Duplicates) for the relevant fields. Make sure that the table does not yet contain duplicates.

 

[janith]

thanks can you please also help me with this query I've 2 combo box on my form , 1)status 2)refer reason. What i want is when the form loads the refer combo should be disabled and it should only be enabled when i select the value "refer to tl" from the status combo box, any help thanks

 

[cookiegary01]

Hi,
Do you know how to disable the refer combo box?
Does " Refer to tl" in Combo box "Status" have a unique autonumber?