• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Designing Custom Multitable ... > Completing the Main Personnel Action...

Completing the Main Personnel Actions Entry Form

In the following sections, you learn how to use the Control Wizards to help you add a subform to a form. Before you add the subform, however, you should complete the main frmPersonnelActionsEntry form. Like the form that you created with the Form Wizard in Chapter 12, the purpose of this form is to display records from the Personnel Actions table so that a user can view the history of an employee's personnel actions. The form also conveniently provides a means of adding new personnel action records.

In the form you created in Chapter 12, you viewed the history of personnel records and also added new records in a tabular subform, while information from the Employees table was displayed only on the main form. In this custom form, you place fields from the Personnel Actions table on the main form to make adding new records to the Personnel Actions table easier, and the Tab control is used to contain the subform as well as additional information from the Employees table. The subform on the second page of the Tab control displays only historic personnel action records. The frmPersonnelActionsEntry form has fields from the Personnel Actions table on both the main form and the subform, and it uses the qryPersonnelActions form you created at the beginning of this chapter as the form's data source. If you were creating a full-scale human resources database application, you might choose the Employees table as the data source for the form and design a subform for editing the Personnel Actions table. You might then put this subform on a third Tab control page or display the history in a subform of the subform.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint