Can somebody give me some code that will prevent my users from entering a duplicate value into an embedded subform.
My main form is called, frmMainForm and my embedded subfrom is called, frmSubForm.
The subform is formatted as a datasheet and contains a field called cboYear.
I want to prevent my users from entering in the same year twice in the Year field on the subform.
Thought about setting an index on the underlying subform table but since it's a related table, it can potentially have the same value entered twice in the table .........I just don't want it to appear twice when viewing it as a subform.