[Solved] IF check on Text Box

Creating and using forms
Post Reply
monti
Posts: 3
Joined: Thu Jan 19, 2017 1:46 pm

[Solved] IF check on Text Box

Post by monti »

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)

Image
Last edited by RoryOF on Tue Jan 31, 2017 12:27 pm, edited 3 times in total.
Reason: Added green tick [RoryOF, Moderator]
LibreOffice 5.2 on Windows 7
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: IF check on Text Box

Post by UnklDonald418 »

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
monti
Posts: 3
Joined: Thu Jan 19, 2017 1:46 pm

Re: IF check on Text Box

Post by monti »

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.

Image

Image
LibreOffice 5.2 on Windows 7
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: IF check on Text Box

Post by UnklDonald418 »

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.
New Database01A.odb
(22.67 KiB) Downloaded 213 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
monti
Posts: 3
Joined: Thu Jan 19, 2017 1:46 pm

Re: IF check on Text Box

Post by monti »

Thank you for helping me on this!
Now i understand clearly how this works.
LibreOffice 5.2 on Windows 7
Post Reply