Automatically change default value

[rbrule]

I have a table that contains two fields "status" and Date". I have set the status field to the default value "available". I would like the value of the status field to change to "not available" automatically when the date field is filled in. I believe I need a SetValue macro, but I have not been able to make it work.

Can someone help me out with this?

 

[TedMartin]

Are you accessing the raw directly in the table or via a form. Changing the default value in a form via an IF statement code would be straightforward.

 

[rbrule]

I set the default value for the status field to "available" in the table. I was trying to have it change to unavailable when a date was input through the form. My intent is for the data to be saved in the table, not just show on the form, like a calculated field. I suspect that I don't have the SetValue action set up properly. I set the condition to: [forms]!

![date] Not is null Action: SetValue Item: [forms]!

![Status]."Not Available" expression Yes