Updating Data using a form

[uniroyal2001]

Hello Friends,
I am using a Access 2000 database to records absentism at my store. I have a switchboard I use to access my form where I select my employees name and date they took holiday and other details..
Thats working fine.
The situation is..whenever someone requests a day off in advance I enter that information on the database. But if they dont take that holiday then I have to go behind the scenes (directly into the table) and delete that previously entered record.

Is there anyway I can create a form where I can select the employee's name and it will show me all entries for the person..and I can just check the records I want deleted or edited..make the changes..and click save..

An ideas on how to proceed on this idea..

Thanks in advance..

John Pasron
JP Bridalwear Solutions Inc.

 

[pbrown77]

Best way I have found is to make a form based off a query and under the name or id field in the query = [Enter name or number].
That way the form will only open records associated with a particular person.