Changing fields to must populate

[spock1971]

Hi Everyone

I need to change a fields properties on a form depending on another fields data.

i.e. If a user ticks a Yes/No box saying they've done something they must also complete the date they did it. I can't set the date field in the table to be 'Required' as if ther is no tick then it doesn't need to be.

Cheers

D

 

[Pauldohert]

Maybe you could do away with the yes/no field. ie Entering a date is the same as ticking yes any way.

 

[neileg]

I agree with Pauldohert, it's not needed. If you need to do conditional validation you will have to do it in a form, not at table level, any way.

 

[spock1971]

Yeah - I've got it on a form currently and the company want a tick and date.

So how do I do it on the form?

Cheers

D

 

[Pauldohert]

Be extremely careful of doing exactly what the company wants.

A compromise of not actually storing the Yes/NO but displaying it somehow may be the way forward.