Avatar

Level 1

I am new to Adobe Live Cycle, my background is in SQL and Access.  I have a form in Adobe that is linked using a DSN to an Access dbf and it is working fine.  The end user clicks on a submit button and the data is then in the dbf.  The form is a Checklist that end users complete daily. 

I would like to streamline one part:  If the end user types into the comment txtbox I want the no checkbox to automatically be unchecked and the yes checkbox to be yes instead of having the end user choose yes (default is no).  Could anyone give me specific code? or solution?  (p.s. the company that I am working for wants both a yes checkbox and a no checkbox).  If there is no comment then I want the no checkbox to be checked which is default.

The form example:

     Safety Check            YES               NO                 comment

          machine 1      checkbox        checkbox                - types here (I want automatic feature to have yes =true, no=false)

          machine 2      checkbox        checkbox          

Hope I am explaining this well enough.....thanks