Index / NoDups

[3535]

I set up a phone field and set IndexYes NoDuplicates to it.<br>
In Table view, it works fine and does not allow Duplicates.<br>
On my form it does not prevent duplicates.<br>
Is this correct? How can I prevent Duplicates in a field on my form ?<br>
<br>
<br>
<br>
<br>

 

[WP]

If your form is bound to the table then the record should not add if the phone number already exists.<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[3535]

Bound? How do I bound or how can I check if my tables are bound? Thanks, Ray<br>
<br>
<br>
<br>
<br>

 

[WP]

A form with a bound table means that when you enter info to the fields you are effectively writing a record to the table. If you created the form with the ACCESS wizard the it will be bound.<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>