Hi,

I'd like to set up the following validation:

The allowed options in column A should be the total number of entries in column B, except those entries for which the value in column C = "Not a valid option".

Is this possible? I suspect i'll have to venture into some VBA wizardry of which I have a limited amount of knowledge from Access. Any hints?

Thanks,

Jens Maigaard