View Single Post
  #5  
Old May 19th, 2010, 02:39 AM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default How do I populate a subform field with a value from the main f

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


"SSi308" wrote in message
...
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.

"Arvin Meyer [MVP]" wrote:

You don't ever need to store the name in 2 places. The only data that
should
ever be duplicated is the key.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"SSi308" wrote in message
...
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?



.