Avoiding duplicate dates

[not a code fan]

Hi there

I want to avoid duplicate dates in the date field of my form. It's a little more tricky than it sounds though. Imagine two fields in a form; one list box of eleven values and one date field. Once i have chosen a value from the list box i enter the date in the second field. It is ok for one value to have the same date as another value (in another record) but i don't want to have duplicate dates for one value. Any idea how to SIMPLY overcome this problem?

Not really looking to fully understand how it all works, i would be happy just to fix the problem.

Cheers

 

[FoFa]

Make the date field disabled until they select something from the list box.
Then when they enter a date (via something like the lost focus or before update event as an example) run a DCONT to see how many records exsist with those values already. If zero, no problem, if > zero, let them know.
Just my 2 cents worth.