Records in tables

[RonnieODIN]

Hi,

Am I able to make sure that a value can be applied to only one record? If so how then?

Thanks

-Ronnie

 

[John Big Booty]

You could test DCount() in the Form's Before Update event to ensure that a particular value has no been previously entered.

 

[Pat Hartman]

You can define a unique index and let the database engine take care of it.

 

[John Big Booty]

:banghead: and set the Indexed property to Yes (No Duplicates)

It oh so simple when you stop and think for a moment