Controls

Re: Check Checkbox from queried textbox result1

super8jeff — Fri, 02 Aug 2013 13:08:09 GMT

Thank you for your reply! Please find the .xsn atttached. You can see the checkboxes that I would like to show checked with the corresponding score.

Re: Check Checkbox from queried textbox result

super8jeff — Fri, 02 Aug 2013 13:06:19 GMT

I appreciate your reply! Please find the xsn attached. You can see the checkboxes that I would like to show checked with the corresponding score.

Thank you so much for your time!

Jeff

Re: Check Checkbox from queried textbox result

Patrick Halstead — Fri, 02 Aug 2013 07:20:01 GMT

Hmmm, may be a simple data type issue. SQL data types are not XML data types.

Can you attach you XSN so we can have a look? Go to options tab and add it.

Check Checkbox from queried textbox result

super8jeff — Thu, 01 Aug 2013 11:55:10 GMT

Forum of Awesome,

I have a scoresheet that when a name is queried the persons scores show in a bound textbox. (Data is save in a SQL 2008 DB). Because board members can score from 1-7 in 11 different categories I did not want to create that many fields in my SQL DB. Rather, when the score returns in the textbox I want the appropriate checkbox to show checked. So if the receive a 5 then the checkbox under 5 turns on when the quergy is run. I have found answers here but it seems to only work if the a number is manually entered into the textbox not when it is pulled from a query.

I hope this makes since.. and I appreciate your time!

Jeff