Duplicates

[TobyMace]

Hi All,

Is there a way of allowing some duplicates through in column A but only if column B equals a certain value?
I would define the value(s) in column B and this would allow any entry into column A any number of times. Otherwise duplicates are not allowed in A.

Thanks.

 

[bob fitz]

I'd use the BeforeUpDate event of the form used to enter the data to handle the validation. If the validation fails the update can then be cancelled.

 

[Galaxiom]

I suspect your data structure may have room for improvement. It is usually the case when trying to partly disable functionality.

Can you describe what you are recording?