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
After I posted this message I kept reading different postings and decided to change my checkbox to a radio button to eliminate the posibility of both checkboxes being checked.
However, now I have another problem . Only the yes radio button is connected to the database - however it is always true (1) even if it is not selected. ? because they are part of the same radio button group? but I need them to be in the same group to allow for only one selection.
And I wish for the end user to not select yes or no (no being already default & checked) but only start typing in the comment section and then the button would change to yes.