Commit Record Immediately on Field Entry

[oilcan]

I have a field that is a Yes or No Radio button. I am using the visibility trick to show or hide some items in a portal. It works well, except that if you make an entry to the Yes or No radio buttons, you then have to click somewhere else on the layout to commit the record, and thus show or hide the items in the portal. This will do, I guess, but my preference would be that a click on either radio button would automatically commit the record, thus revealing or concealing the objects in the portal immediately.

If anyone has a notion of how I might accomplish this I'd be interested to hear about it.

[comment]

Make the field a button that runs a script. The script will toggle the field and commit.

[sbg2]

Or use seperate radio buttons for each choice. v7 example attached.

Commit.zip

[oilcan]

perfect. this site is such a tremendous resource to somebody such as myself that is trying to struggle through the learning process. once again, thanks.

[oilcan]

Or use seperate radio buttons for each choice. v7 example attached.

sbg2, I have a question for you.

I have implemented your elegant solution into my database and it works beautifully. However, there is something I did not quite understand about it. On your relationships graph you had two occurrences of the Graphics table, one of which was relating the Graphics table primary key to the yes boolean in the Commit table. Was this a 'typo'? What purpose did it serve? I've removed that relationship and the second occurrence of the Graphics table from my solution, and everything still seems to work fine. I am just trying to understand what these other things were about.

Thanks.