InfoPath Dev

I find default values really problematic in a lot of circumstance. Have you considered using a form load rule instead? Just leave the list column without a default and add a rule in the form load rules to set the field to the default value you want if the field is blank - or if you only want to do this in a new form, if the ID field is blank.

I'm having a little trouble understanding - but my guess is that ID isn't equal to what you think it is. If you look in the list, what are the values in the ID column? Are any of them "Others" or "Any Others"? You can always attach a copy of your form or a screenshot under the options tab in a reply to help explain the ...

Glad you have it working & thanks for the compliments - have a great day!

The InfoPath Whisperer...you never cease to amaze me. Your solution has my form working like a charm. Is there a survey I can fill out to let your employer know how amazing you are and how well you know your stuff? Thanks so very much! 10 Star Service...

I didn't realize the field in question was in your repeating table - your hidden field also needs to be in the repeating group, because if there are 15 rows, you might have 15 different values for the SHIP Plant, right? I've attached an updated file here - save it locally, right click and select Design to open in InfoPath Designer. The ...

oh, and sorry, here's the latest xsn file...i played with another rule for the hidden field

The hidden field...tried various formulas but none are getting me the result...

Yes Hilary, I already had the SP list and had the Ship field set with a data connection and email as Value and Plant # as Display.

This gets a little tricky with a hardcoded dropdown. If we put this data in a secondary data source instead, it gets a lot easier. I'd suggest you create a SharePoint List for this data - it would have two columns - one for email, one for name. Then you can add a data connection to that list, and use it for your dropdown, with the email for ...

Attaching your screenshot to this post, and closing the other thread - you can always just add a reply to your thread with each additional file.