Hi,

Since a full date is not recorded, my form has a MonthID field (Number
datatype) and a YearID field (also Number datatype).  Both receive values via
a combo list.

I would like to have the form validate that the month and year combination
that are selected do not already exist in the underlying table.

Is there a DCount or DLookup statement or something else that can validate
both field values by checking the existing records to see if the combination
already exists within a record in the underlying table?

Any help would be greatly appreciated.

Thanks,
Jody