[Solved] IF check on Text Box

by **monti** » Mon Jan 23, 2017 5:03 pm

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)

by **UnklDonald418** » Thu Jan 26, 2017 6:15 pm

I have attached a sample database. Based on my understanding of you question I believe Form_complete accomplishes what you are asking.

by **monti** » Mon Jan 30, 2017 5:16 pm

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.

by **UnklDonald418** » Mon Jan 30, 2017 10:46 pm

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 124 times

by **monti** » Tue Jan 31, 2017 11:57 am

Thank you for helping me on this!
Now i understand clearly how this works.

[Solved] IF check on Text Box

[Solved] IF check on Text Box

Re: IF check on Text Box

Re: IF check on Text Box

Re: IF check on Text Box

Re: IF check on Text Box

Who is online