I am new to MS Access and Database creation in general. Currently I am working on a simple employee database that can view an employee's information and can show their current (and previous) projects and training courses within the company. Below is a snapshot of my Relationship Chart.

enter image description here

My question is twofold,

1.) I am working on a subform that shows the projects currently and previously taken by an employee (The Project Status table shows either Current or Previous status. More can be added later on). When I create the subform however, it only shows the first entry, regardless if the employee has multiple entries. Below is a picture of the form. enter image description here

2.) Is there a more ideal way to create a form that gets sources from 2 different queries than getting a mainform and putting a subform inside? As you can see I am getting the entries on the form depending on the combo box selection. Furthermore, is there any way to make a dynamic subform that can expand depending on the number of entries it outputs? My gripe with using a Continuous form is that it also shows the blank "next" entry.

Many thanks.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.