I have created a PTO Submission for our employees.  All the data is aggregated in an SQL database.  The open and closed requests are then displayed on the submission form for the employee to see the next time they make a request.  This data is also used for formulas.  The Open and Closed requests are pulled from the SQL table in a lookup routine and placed in a read only table that is auto filled by the lookup.  work great once the on the initial form.   Once the employee submits the form, some of the data disappears.  As you can see below,  all the dates remain but the hours requested for each day disappears.  This happens on the confirmation form that the employee can print, the approval form that the manager approves as well as the PDF that is saved to the employees folder.  Thoughts?

This is what it looks like before the employee hits submit.

Here is what it looks like after submission - you can see that the dates are there but the corresponding hours are not.