Desktop

Ask something
Discussion Locked

Design an MS Access form with 2 subforms

0 helpful
2 replies

by donjg

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Using Microsoft Access, how do I design a form containing two subforms, linking the data to establish instant updates?

ProgramDate Form
The Form?s primary key should identify each unique combination of two specific fields: (1) a Program field; and, (2) a Date field.

Client Subform
The first subform should comprise a datasheet of Client records (First Name, Last Name, Level of Care, Hours) reflecting the attendance of each Client present at the Program and on the Date specified in the appropriate record of the ProgramDate Form.

Personnel Subform
The second subform should comprise a datasheet of Personnel records (Name, Status, Hours) reflecting the composition of staff at the Program and on the Date specified in the appropriate record of the ProgramDate Form.

2 replies

by john_wills

Both of your subforms should be continuous. Each subform should have, from the main form, child keys set to program and date from the main form. Each child form should have data from the appropriate table (attendance?) with joins to the substantive tables (client, staff?) to fill the form.

This discussion is closed to new replies.