Hi dears,
I have a small issue with creating new record.
like i have
2 Tables: Emp_Data, Over_Time, Emp_No is the primary key in both tables.
2 forms, Main_form, Sub_form
Main form has fields, Emp_no, Emp_Name and a search field to search records by any one of 2 fields
and Subform is DataSheet mode to display records of selected field(can be any of above 2 as base to search).
Corresponding display records will be are Emp_no, Emp_name, Emp Branch,Over_TimeDuty_on
now my problem is I want to add a new record in subform datasheet of existing records for selected Employee.
To be more clear what i require:
In Main form - search by Emp_no and enter in textbox as 0025 then
in subform DataSheet- 4 records of selected employee will display with different Over_TimeDuty_on
now I want to enter new record in Datasheet as 5th entry.
but I have to manually enter Emp_no, Emp_name,Emp Branch, Over_TimeDuty_on details in the 5th record.
It should be autofilled all the details of selected Employee except Over_TimeDuty_on field in the new record.
pls help here.