SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have 1 Requirement list and 1 Tasks list with InfoPath 2010 forms.

  • Tasks list having Lookup column as of Requirement Title field.
  • Both lists having Status field.

When user save Requirement (InfoPath form) with Status=Completed I want to check whether there is any corresponding tasks exist in tasks list with Status != Completed.

if so I want to show a message (or form validation) to the user saying

"Corresponding Task is open for this requirement.Please complete the open task in order to complete the requirement."

Is it possible?

share|improve this question
Yes, you can do it using custom code.. – Viraj Gorajia Jan 22 '13 at 6:23
Thanx for your replied. i have sharepoint list infopath. is it ok? can you please guide me regarding this? – Dhaval Kariya Jan 22 '13 at 6:39
Is there multiple tasks for single requirement? Ya almost part i have done but I can not check status of task that is completed or not. But i can check that task is exists for that requirement. – Viraj Gorajia Jan 22 '13 at 10:54
yes there are multiple tasks for single requirement – Dhaval Kariya Jan 22 '13 at 11:49

Concerning comment " you can do it using custom code":

What is asked is unclear - what is the type/compatibility of Iinfopath form and which version of Infopath?
Why do you need messagebox but not validation rules or conditional formatting to show and hide a section ?

share|improve this answer
Thax Gennady Vanin, i have updated my question. i dont have any problem if it will be validation rules instead of message box. can u tell me how can i perform that? – Dhaval Kariya Jan 22 '13 at 10:23
I do not see anything making your question more clear. – Gennady Vanin Геннадий Ванин Jan 22 '13 at 10:44

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.