Page 1 of 1
[Solved] Check in Check Box continues to next record in sub form
Posted: Mon Aug 22, 2022 11:12 pm
by Dalke55
I have added a BOOLEAN field to a sub form and attached a CHECK Box for that field. My issue is when I click the box for the check option and move on to the next record in the sub form the box in the next record already has a check in it. How would I set the check box to clear on the form after going to next record. The Table fields are correct for the last record entered.
Attached image of Check Box properties General & Data tab
Thank You!
Re: Check in Check Box continues to next record in sub form
Posted: Tue Aug 23, 2022 6:26 am
by UnklDonald418
Open your table in the Edit mode and select the field TNT-BLU X
Make sure
Default value is set to
No
Example attached

- Screenshot_20220822.png (15.39 KiB) Viewed 10543 times
Re: Check in Check Box continues to next record in sub form
Posted: Tue Aug 23, 2022 6:14 pm
by Dalke55
Thank you, as soon as I get DBSchema to import my database schema I will make that change as the current setting is <none>. I cannot directly modify my HSQLDB ver2.3.2 with the editor.
Im currently waiting on DBSchema support so my result may be in a day or two.
Re: Check in Check Box continues to next record in sub form
Posted: Thu Aug 25, 2022 6:22 am
by UnklDonald418
You should be able to make the needed change at menu selection
Tools>SQL by executing a command of the form
Code: Select all
ALTER TABLE "YourTableName" ALTER COLUMN "YourColumnName" SET DEFAULT 'SomeValue';
In your case substitute "TNT-BLU X" for "YourColumnName" and FALSE for 'SomeValue'
Tools>SQL bypasses Base and works directly with the back-end engine, in your case HSQL 2.3.2
To inform Base of the change(s) select TABLES from the main Base window
Then from the menu select
View>Refresh tables
Re: Check in Check Box continues to next record in sub form
Posted: Thu Aug 25, 2022 1:30 pm
by Dalke55
Thank You! Before I saw this last post I had an issue with BASE EDITOR, FORM NAVIGATOR and looked up a link that said to reset the user profile which I did, and fixed Form Navigator. I also found the CHECK BOX functioned properly and cleared when going to next record.
Thanks again