I have this form with SubForm that i used to enter data .. I want to copy or retain all data or entries in my "Days" & "Month/Year" fields after saving, thus leaving my "Employee ID" & "Hrs. Worked" Field Blanks.. see sample below.. Thanks in advance for any help..
(The number of rows may varies from time to time.. in this example there are only 5 rows or 5 days.)
Example: 1. Form and Subform Entry before saving the data.
Employee ID: 1234
SubForm (Linked From Table)
------------------------------------------------------------------------------------------------
EmployeeID=== Days=== Month/Year=== Hrs. Worked
------------------------------------------------------------------------
1234=========== 1 ======Feb 2012======== 8
1234=========== 2 ======Feb 2012======== 8
1234=========== 3 ======Feb 2012======== 4
1234=========== 4 ======Feb 2012======== 4
1234=========== 5 ======Feb 2012======== 8
Example: 2. Form and Subform after saving the data.
Employee ID: _____
SubForm (Linked From Table)
------------------------------------------------------------------------------------------------
EmployeeID=== Days=== Month/Year=== Hrs. Worked
------------------------------------------------------------------------
_____=========== 1 ======Feb 2012======== __
_____=========== 2 ======Feb 2012======== __
_____=========== 3 ======Feb 2012======== __
_____=========== 4 ======Feb 2012======== __
_____=========== 5 ======Feb 2012======== __
(The number of rows may varies from time to time.. in this example there are only 5 rows or 5 days.)
Example: 1. Form and Subform Entry before saving the data.
Employee ID: 1234
SubForm (Linked From Table)
------------------------------------------------------------------------------------------------
EmployeeID=== Days=== Month/Year=== Hrs. Worked
------------------------------------------------------------------------
1234=========== 1 ======Feb 2012======== 8
1234=========== 2 ======Feb 2012======== 8
1234=========== 3 ======Feb 2012======== 4
1234=========== 4 ======Feb 2012======== 4
1234=========== 5 ======Feb 2012======== 8
Example: 2. Form and Subform after saving the data.
Employee ID: _____
SubForm (Linked From Table)
------------------------------------------------------------------------------------------------
EmployeeID=== Days=== Month/Year=== Hrs. Worked
------------------------------------------------------------------------
_____=========== 1 ======Feb 2012======== __
_____=========== 2 ======Feb 2012======== __
_____=========== 3 ======Feb 2012======== __
_____=========== 4 ======Feb 2012======== __
_____=========== 5 ======Feb 2012======== __