I've a data entry form which only allows new records to be entered. There're 3 combo boxes bounded to the fields of an underlying table. There're cases when the user selects existing values from the first two comboboxes but the entry in the third combobox is a new value, thus making it a new record.
The comboboxes're not limited to list, so as to allow new entries in each combobox. Is there there a way to detect the entry of existing records and reject them (writing codes in certain event procedure)?
The comboboxes're not limited to list, so as to allow new entries in each combobox. Is there there a way to detect the entry of existing records and reject them (writing codes in certain event procedure)?
