Using sub-forms

[Neil_Pattison]

I have 2 tables for an attendance database. The idea is that whenever someone is absent they have a record created.

tbl[Staff] has the following fields StaffID,FirstName,Surname,Team,Job Title
tbl[Absence] has the following fields StaffID, abStartDate,abEndDate,abIssue

I have set up a form for the [Staff] table and included a sub-form for the fields in the [Absence] table. I want to set up this form so that so that the user can either add or edit data in the absence table, i.e. if someone is sick they can add a record to note it.

I'd like to develop a query that would allow the user to enter a surname and bring up all the relevant absences to that person so they could be edited. I can set it up to find the individual but the records on the Absence sub-form don't navigate. Any idea how I can do this?

 

[Sergeant]

Look at the properties sheet for your subform (with your main form in design view). Under data tab, select appropriate parent and child fields to relate. The rest is magic.

 

[Neil_Pattison]

thamks sergeant