Adding single record

[Neil_Pattison]

I have 2 tables and a query to show the details of both tables on a form for an attendance database. The idea is that whenever someone is absent they have a record created.

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

I can set up the query to find the member of staff by name but I want to be able to use this form to add new records to the Absence table for each individual. eg I use the query to search for "Joe Bloggs" and the form shows the details from staff table and then use the form to add details to the Absence table.

Any help would be greatly appreciated

 

[lcross]

try to use a form with a sub form linked access as a wizard for it.
when you select a member of the staff it shows the details for thet id, got it?
hope it helped.

 

[Neil_Pattison]

thanks have it sorted now