General

Re: Conditional formatting doesn't apply following a query submission

Jimmy — Wed, 10 Mar 2010 17:05:31 GMT

This is a perfect time for a secondary XML data source. Just create a simple XML file in notepad like this (come up with better names for the elements):

<SectionShowing>
     <Section1>no</Section1>
     <Section2>no</Section2>
     <Section3>no</Section3>
     <Section4>no</Section4>
</SectionShowing>

and add the XML file as a data source in your form. Then bind the checkboxes to those fields. This way you don't have to involve them in your Access query, and they won't be affected by your querying the database.

Re: Conditional formatting doesn't apply following a query submission

janderson — Wed, 10 Mar 2010 16:48:58 GMT

Thanks for such a rapid response!

All the boxes are set up as a "yes" / "no" for the true or false. The variable sections are then formatted to Hide if the value of the one it's paired with is "no". The fields of the actual checkboxes are bound to fields within the same DB table but this is only for convenience as I couldn't work out how to have them "stand alone". They're purely functional and have no meaning other than control within the form.

I'll have a play about with them as per your suggestion and see if it throws anything up.

Thanks for the help mate.

Jon

Re: Conditional formatting doesn't apply following a query submission

Jimmy — Wed, 10 Mar 2010 16:38:19 GMT

What exactly is the conditional formatting condition on each of the sections? Is is just based on whether the checkbox fields' values are one value or another? Are the checkboxes bound to fields that are returned by the query?

One thing you can do is display the checkbox fields' values in an expression box to see if they are taking on an unexpected value. Maybe they have the value 1 instead of true in which case the conditional formatting wouldn't apply, or something like that.

Conditional formatting doesn't apply following a query submission

janderson — Wed, 10 Mar 2010 16:22:41 GMT

Hi, I'm really hoping someone out there can help me with this one, I can't find the solution anywhere!

I've designed an InfoPath form, linked to an Access Database. The purpose of the form is to query a central database for a customer record, if it finds one it returns various field values. Additional fields in seperate sections are then populated by the person using the form and then the whole thing is re-submitted back to the same database. The fields that are updated are the customer's requirements for a specific public holiday.

At the top of the form I have a series of check boxes, each with a unique date next to it. Checking one or more will display a specific linked section. Without any checks, no sections are displayed. This is to make sure that the 30 or so public holidays dont all display at once, keeping it nice and clean.

I've done this with conditional formatting and it works fine for when I'm entering a new customer. However, when I run a query first which returns a customer record, all the other sections display, regardless of whether they have any values or not. I can then check and then uncheck the boxes and one by one they disappear , but this is far from ideal. It's almost like the conditional formatting isn't being applied when I'm running a query.

Does anyone have any suggestions?

Thanks guys n gals, Jon