How do I populate a subform field with a value from the main form?

[SSi308]

I have a form called ContractsIn which has a subform called
ContractsInAndHours.
The main part of the form consists of:
Employees.ID
Employees.Name

The subform has the fields:
ContractsAndHours.ID
ContractsAndHours.Name
ContractsAndHours.DailyHoursWorked
ContractsAndHours.ContractOut

This form is used by the supervisor to enter the hours worked and the
contracts in for each day.
When entering hours and contracts for each employee I would like the Name
field in the subform automatically filled in with the name in the main form
when entering through the field.

Can this be accomplished?

 

[Arvin Meyer [MVP]]

You don't ever need to store the name in 2 places. The only data that should
ever be duplicated is the key.

 

[SSi308]

How does the table know who the record is for when running reports?
For example the ContractsAndHours subform was created from the
ContractsAndHours table. If I do a query on the ContractsAndHours table
information and there is no name field how do I sort by employee name?

Thanks for the reply it is very much appreciated.

 

[John W. Vinson]

How does the table know who the record is for when running reports?
For example the ContractsAndHours subform was created from the
ContractsAndHours table. If I do a query on the ContractsAndHours table
information and there is no name field how do I sort by employee name?

Join the Employees table in the query: pull the contract and hour information
from the ContractsAndHours table, and the name from the Employee table. That's
what relational databases DO - let you combine data from multiple related
tables into one result.

If you're assuming that the Report must be based on a single table containing
all the needed information, you're missing the real power of databases!

 

[Arvin Meyer [MVP]]

You use a query to sort and the EmployeeID to identify the employee. A join
on EmployeeID from the employees table will display a name.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access