View Single Post
  #1  
Old May 17th, 2010, 06:11 PM posted to microsoft.public.access.forms
SSi308
external usenet poster
 
Posts: 42
Default How do I populate a subform field with a value from the main form?

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?