InfoPath Dev

I have 2 lists. List one (1) captures a set of data from users (weekly reports). The other list (2) will only query the data to consolodate all submissions from list One (1). The query is based on the week ending field (Date Picker). Process: 1.) Users submit weekly reports to list one. 2.) The Admin opens a custom form in list (2) and enters the week ending date and all the submissions from list (1) show up with the same week ending date. Problem: When the user saves the form and opens it back up the queried date is missing and none of the queries show up. What switch am I missing to make this work. Thanks for your help.

No one knows the answer? I figured this was an easy issue but i guess it is not.

Maybe better clarification of the issue:

• Form has a date field
• Date Field Queries a Sharepoint list based on the Date field. (This is working great. I enter the week ending and all submittions that match the week ending show up in the repeating table.)
• I hit submit.
• Open the library where the form was submitted
• No Data is present and the date field is cleared.
• I can open the submitted form again and enter the date and the query will work. Once I save it, all items are blank.
• Any help would be greatly appreciated. Thank you!

 Please let me know what checkbox I am missing so this information is saved.  

-Noah

 

 

Hi - is the date field in your main data source?