Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Lotusscript Check/Uncheck a CheckBox

Posted on 2011-10-05
Medium Priority
Last Modified: 2013-11-16
Hi Experts

I have form1 where we register all Sections, for example sake we'll use Section1, Section2, Section3. This form have a CheckBox that decides what type of Plans are allowed to create, the options are Semi Annual, Quarterly, Monthly and Periodic.

When user create a document with form2, and select the Section from a Combobox, OnChange event will set some fields value, which is working fine except for the Checkbox field.
The CheckBox field have the same values as form1, computed.

How can we fix that ? hope my explanation is clear. Cheers

Question by:Faraj1969
  • 2
  • 2
LVL 10

Expert Comment

ID: 36923624
So the two forms are similar in that they both have a checkbox with computed options.
Do you mean it is an editable check box (1st tab on field prop) and the options are based on formula (2nd tab on field prop).

Primary is ensure that checkbox field has the option "Refresh choices on document refresh" and that combobox has option "Refresh fields on keyword change"
or that your OnChange code does not cause an error which would stop the refresh event happening.


Author Comment

ID: 36923782
Form1 have the CheckBox editable, Form2 have it computed, the Administrator will set the CheckBox value in Form1. In Form2, based on the user selection for the Section, the CheckBox will just show what values the Administrator selected in Form1. I was able to do that with all other text fields, but not the CheckBox. Also I already did the options you mentioned. Many thanks for the response and support.
LVL 10

Accepted Solution

doninja earned 2000 total points
ID: 36923831
A computed check box is just a field as it's value is fixed, so not really a good idea to have it computed.
You may as well just have a text field that is computed and that will save all this problem. If you want it to look good then have some hide formulas that show tick graphic next to selected options.


Author Closing Comment

ID: 36923837
Many thanks for the support.

Best wishes

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question