paulwoods23
IS-IT--Management
I have a database used to store staff sickness. It currently consists of a "Staff" table to store staff details (name, number, salary etc) and a "Sickness" table to store sickness records.
I have produced a form to displaying staff's name from "Staff" table and then a linked sub form containing existing sickness records from the "Sickness" table.
The idea for this form is to be used to add new sickness records and also to display existing sickness records. To do this I would like to add a filter to the form where the user can add start and end dates into text fields on the main form and display only records between a chosen dates in the sub form (apply filter??).
I have never tried to do this before and don't know where to start. Any ideas?
I have produced a form to displaying staff's name from "Staff" table and then a linked sub form containing existing sickness records from the "Sickness" table.
The idea for this form is to be used to add new sickness records and also to display existing sickness records. To do this I would like to add a filter to the form where the user can add start and end dates into text fields on the main form and display only records between a chosen dates in the sub form (apply filter??).
I have never tried to do this before and don't know where to start. Any ideas?
