Data Entry in SUBFORM

[flsticks]

I have a database that each month I assign various tasks to multiple people. I am trying to auto fill some of the information from one table to a new record in another table. People: Hireid (primary key) name, supervisor, role etc. Assign: empid (primary key matches hireid) AssignMonth, supervisor week1assignment, week2assignment.
I am trying to make a subform that auto fills the empid (hireid from People table) in the subform so I don't have to fill out information I already have. The Assign table is empty. Is there a way to auto fill a table with the subform when there are no records in the subform table...and how if you can. thanks

[pkstormy]

It sounds like you want to set the default value of a field (empid) on the subform.

If empid is on the main form, you can put into the default value property of this field on the subform this: =Forms!MyMainFormName!empid.