How do I populate a subform field with a value from the main form?
in [Form]
|
Prev: How can I update the data listed in the combo box to show the most
Next: Access runs slow under Windows 7
From: SSi308 on 17 May 2010 13:11 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?
From: Arvin Meyer [MVP] on 17 May 2010 14:34
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" <SSi308(a)discussions.microsoft.com> wrote in message news:8397B7AC-C8C5-4B9F-A57C-F2A1FF726AA9(a)microsoft.com... >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? > |