InfoPath Dev

sitting with a sheepish grin..... nope rule 1 wasn't running.  I changed the condition to look and see if timesheet_id is not blank for the condition.  works like a charm.  I guess my trying to look smart with a fancy command didn't work out too well. Thanks Hilary, you rule Now on to finding my next challenge... ...

yes the 1st step in each rule is a condition.

Ok not sure how I screwed up the previous post but lets try again. I attached a picture of my data source.  I still cannot get the is_approved field to show true when its been updated in the database.  The entry table and approved table are linked to the timesheet table via the timesheet_id. I have two rules set to run when the form ...

I used the XDocument.IsNew = false expression and that seemed to work.   ^^^^^^^ as always I'm overlooking the obvious easy answer... lol

Thanks so much for your help Hilary, I am actually making some progress YEAH.  The only problem I have right now is when I open a blank form it is running the query and grabbing the ID of the first record in the database.  I'm sure there is a property field or another rule I can run to only run this query if its not a new form.  ...

I completely understand the logic.  now my problem is I don't understand how to implement it.  Do I need to bind the approved field on the form to approved in the query data source or the table source?  I guess my next question is I don't know what you mean by run my main query?  I am really new to info path and ...

I placed the approved field on the top of the form and set an open rule that if approved is true open in read only view.  I then entered a test form which submitted to the database with no problems.  I then went into the database and set the approved field to true.  I then reopened the saved infopath form and found that it still ...

I have created a timesheet entry form in infopath, which sends the information back to an access database.  I have two tables setup in my mainsource data connection.  One table is Timesheet which has an auto generate number for each timesheet entry.  This table also has the employee info, work crew, work date, approved check box, ...

thanks worked like a charm.

hello all and thanks in advance for your help.  This is my first time using infopath and I am slowly learning as I go. I am creating a timesheet form with a repeating section.  The section has fields for pay_rate, begin_time, end_time, vehicle_num etc.  What I need to happen is when the section is repeated I need to make sure that ...