Hey,
Im just trying to get everyones ideas on how to do the following.
I have an action item tracker access database that I am trying to make as user friendly as possible. I have a form where they submit action items but eventually they will have to edit the items they submit, for example editing a due date or adding notes or changing who it is assigned to things like that. Right now they are doing it in excel and it seems fine. I dont want them to have to use a form to edit this data because at any given time they can be hundreds of action items.
I wanted them to edit it directly in the table, but I read you are never supposed to use a form to go directly to a table. I just am trying to find the easiest way for them to see all the items, be able to sort the items, and then edit the ones they need to and save it. Any ideas?