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!
[Solved] Check in Check Box continues to next record in sub form
[Solved] Check in Check Box continues to next record in sub form
- Attachments
-
- Image General tab of Check Box Properties
- Properties Check Box - General.JPG (56.1 KiB) Viewed 3471 times
-
- Image Data tab of Check Box Properties
- Properties Check Box - Data.JPG (20.49 KiB) Viewed 3471 times
Last edited by Dalke55 on Thu Aug 25, 2022 1:32 pm, edited 1 time in total.
Apache OpenOffice 4.1.6 Windows 10
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Check in Check Box continues to next record in sub form
Open your table in the Edit mode and select the field TNT-BLU X
Make sure Default value is set to No
Example attached
Make sure Default value is set to No
Example attached
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Check in Check Box continues to next record in sub form
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.
Im currently waiting on DBSchema support so my result may be in a day or two.
Apache OpenOffice 4.1.6 Windows 10
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Check in Check Box continues to next record in sub form
You should be able to make the needed change at menu selection Tools>SQL by executing a command of the form
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
Code: Select all
ALTER TABLE "YourTableName" ALTER COLUMN "YourColumnName" SET DEFAULT '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
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Check in Check Box continues to next record in sub form
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
Thanks again
Apache OpenOffice 4.1.6 Windows 10