No duplicate for a field on the form level?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I know it is possible to set a field proporty to No duplicate in a table.
I want to do this on a higher level...in a Form instead..a ordinary field
that is not a Key field, maybe for a value entered in a cmb box in a subform.

Is this possible?

Mattias
 
Mattias,
Not sure as to why you would wwant to do that but...

If you don't declare NoDupes for a field in your table, you'll have to
manually validate each entry for that field.
On the Before Update event for your field, you'll have to do a DLookup on
that value to make sure it doesn't exist in the table already. If it
does... cancel the entry... if not, allow it.
hth
Al Camp
 
Back
Top