if checkbox true set other field to null

[lotarugg]

Hi,

I have a checkbox and a date field. I want an expression (after update on the checkbox I guess) where if the checkbox is true then the date field should be set to null.

Something like
If [checkbox] = true then [response_date] = null
I'm still trying to learn the syntax. Any help much appreciated
Thanks

 

[Beetle]

The syntax you posted should work assuming the correct field names. Have you tried it?

 

[lotarugg]

Just tried it, it worked :O

Thanks!

 

[Galaxiom]

It is possible that you are breaching normalization if you are storing the value from both the date textbox and the checkbox.

Could the absence of a value in the textbox be used to indicate the information held in the check box? If so the checkbox should not be stored.