How to create a command button on a form that designates which button was clicked in the table that the entry is made?
Background - We orignally had 9 spreadsheets, I combined all the spreadsheets into one table, because all the fields are the same, we will still have 9 people inputting data from different departments.
Date Started
Date Ended
Activity
Detail
Author
Title
Subject
Charged to (text field)
Comments (memo field)
I want to add another field (User1) if User1 button is clicked or (user2 if another button). I need to be able to allow them to run a query based on the entries that each indivdual entered that week so they can add/change entries as needed but only for their own input.
Any help would be appreciated.