I fail to understand why you have a calculated field based upon an input field, with formula basically being "="
Just use your "Field", with autoenter "No" !
I am working on a different form that uses fields from the same table. If I input yes on the form then I want a different table to provide a checkbox.
You could just format the original field with check boxes using a value list of Yes, No.
No need for a calculation.
Good point, and I will more than likely use your solution. KISS - Keep it simple silly. Nevertheless, I am two hours into the previous solution. Do you have a technique to auto fill check-boxes from a calculation field?
Case ( Field = " Yes "; "Yes";
Field = " No "; "No";
It illustrates why you just need to format the original field.
It works now!
I should have not entered the checkbox = "Yes" and just entered "Yes. Thank you for your help.
checkbox = "Yes" is a Boolean expression that evaluates as True (1) if the two values are equal and False (0) if they are not.
But note also that the expression is trivial. I could even simplify it further to be:
Except that an empty field would then show no selected checkbox instead of "No"
Another method is to enter this into the auto-entry calculation for the field definition in Manage > Database. This uses 0/1 rather than yes/no (my preference for Boolean). This method allows a toggle between the two values. Set up a value list for the field, and put only one value in the value list (I would use 1, you would use yes). Then when you click the checkbox on your layout it will toggle between 0/1. Simple.
Use calculated value: If ( IsEmpty ( YourTable::YourField ) ; 0 ; 1 )