Hello
I'm new to Base and out of ideas how to make Text Box show value based on IF check.
(i made drawing with explanation, hopefully its easier to understand)
[Solved] IF check on Text Box
[Solved] IF check on Text Box
Last edited by RoryOF on Tue Jan 31, 2017 12:27 pm, edited 3 times in total.
Reason: Added green tick [RoryOF, Moderator]
Reason: Added green tick [RoryOF, Moderator]
LibreOffice 5.2 on Windows 7
-
- Volunteer
- Posts: 1544
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: IF check on Text Box
I have attached a sample database. Based on my understanding of you question I believe Form_complete accomplishes what you are asking.
- Attachments
-
- New Database01.odb
- (12.79 KiB) Downloaded 212 times
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: IF check on Text Box
Thanks for sample!
Now i understand that label is achieved by subform window
and code is query + filter inside this subform.
However if in form view i set next record and it maches "bulk" then SubForm_details returns same "details" as 1st record.
Now i understand that label is achieved by subform window
and code is query + filter inside this subform.
However if in form view i set next record and it maches "bulk" then SubForm_details returns same "details" as 1st record.
LibreOffice 5.2 on Windows 7
-
- Volunteer
- Posts: 1544
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: IF check on Text Box
Sorry, apparently I didn't do a very good job of checking what I posted.
There were a couple of problems with how the SubForm was linked on the Form. I have uploaded a corrected version with a new Form_complete01, and a slightly modified query for the data source.
I left the old form so you can compare it to the new one.
There were a couple of problems with how the SubForm was linked on the Form. I have uploaded a corrected version with a new Form_complete01, and a slightly modified query for the data source.
I left the old form so you can compare it to the new one.
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: IF check on Text Box
Thank you for helping me on this!
Now i understand clearly how this works.
Now i understand clearly how this works.
LibreOffice 5.2 on Windows 7