lucour
03-13-2001, 03:48 AM
Can anyone help me with the best way to create a Daily checklist in Access? I want the users to be able to update this list on the fly (delete or add new tasks) without having to go into design view. As well, I want these changes to appear on the report that I have created.
Thanks.
llkhoutx
03-13-2001, 09:39 AM
Create a form with the form wizard utilizing the table as the record source. Add AddNew, Save, Delete, etc. buttons utilizing the Tools toolbar icon.
lucour
03-13-2001, 11:12 AM
I should have mentioned the record layout I want. Here it is:
Date (Fld1)
Task List (Fld2)
Initials (Fld3)
ie: March 12, 2001/Check Daily Backups/RA
The Date and Initials fields are the only ones I have set up as bound to table "tblDailyChecklist". For the "Task" field I have just been using labels.
In Summary, each day a new checklist record will be started with a new date and a new Operators initials...however the Checklist task stay the same day after day until such time they need updating.