InfoPath Dev

Jimmy has it right. You have to use the All Instances... and Any Instances... since you are working with repeating data. I attached the updated form.

I always know if I post a note, than I will figure it out.  I used another query that worked:  concat("ModifySqlQuery /dsname=REVENUE /where=where Forecaster='", QueryChange, "'") not sure why the N'" doesn't work in the revenue query but does in the main, but thanks anyway.  :)

First off, LOL. Sorry. Now, Open master, delete all the fields you don't want in form 1, delete all the views you don't want in form 1, save as 'form1.xsn' and close it. Open master, delete all the fields you don't want in form 2, delete all the views you don't want in form 2, save as 'form2.xsn' and ...

Hi.  I am at it again, and now I am trying to add another query.  The original Query:  concat("ModifySqlQuery /dsname=Main /where=where (Forecaster = N'", QueryChange, "')") works fine.  But the following query brings no resulta and checking the command and success of qrules shows no blank after it ...

My mistake on the earlier formula.  I misunderstood your post. Have you tried using the All instances of... option in the Select Field or Group dialog when setting up your condition?

Hi thanks for your reply and for taking the time to create the example for me. I already have these formulas set up in my form and they do work, however my problem is the required fields are in a repeating table so when a new row is added the fields are essentially blank again (in the new row) so the section should re-appear and the ...

In your first post, you said year is 2011, and in the new post you said it's 11.  Is it 4 digits or 2?  And your first post had ../ before the fields, but the new one has ../../../.  Why the change?

I don't believe that InfoPath uses FOP at all.  It generates HTML.  Did you read somewhere that it does? I've never tried this, but it might be possible to use CSS to force a page break before the table.  Of course, this would mean that it would always be on the next page even if there's enough space on the previous ...

Hi, This error usually indicates that some badly formed xml was passed to the web service. Can you check the value being passed into GetMembersOfGroup? Another thing to check is whether the same error happen with other groups. Let us know if the advice above helps. Thanks.

Thanx H,   You rock! as always!