Retains Particular field Entry in Form & SubForm

djossh

Registered User.
Local time
Today, 20:02
Joined
Oct 19, 2011
Messages
89
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======== __
 

Users who are viewing this thread

Back
Top Bottom