VBA code for creating new record

[Naveen Marapaka]

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.

[June7]

Why enter Emp_name, Emp_Branch in the subform record? This is duplication of data. Only the Emp_No needs to be in the subform record. The name and branch data can always be retrieved in query by joining tables.

Why is Emp_no primary key in BOTH tables? Is this a one-to-one or one-to-many relationship? If one-to-many then it cannot be primary in BOTH tables, must be foreign in Over_Time.

If the Emp_no is primary key/foreign key then should not have to enter into the subform. Master/Child links properties of the subform container control should automatically enter the Emp_no in the subform record. http://office.microsoft.com/en-us/ac...010098674.aspx

[Naveen Marapaka]

Hi dear thanks for the reply.

Yes, Emp_No is foreign key, here.

I am not only displaying records in subform as spreadsheet, but also need to edit if any changes to be done in runtime itself, so I changed Subform field of Overtime field locked as no.

the only issue i am facing is one new record to enter in spreadsheet for the same employee!
for this i want, what could be query to enter new record for the selected employee,

pls help

[June7]

I don't understand. If this is a form/subform arrangement with Master/Child links of the subform container control set to the EmpID PK/FK fields, then entry of new record in subform for the employee should be simple and not require code.

Want to provide db for analysis? Follow instructions at bottom of my post.