Hey All,
I have searched for the past 1 hour and couldnt find the exact situation I am in. I will try my best to explain where I am at:
I have a form that is bound to a table that users can access to comment on specific issues pertaining to an item. Each row in the table is a unique set of data that is specific to that item number.
I have 2 fields that the user can edit. The first one is a drop-down that contains specific comments that the user can select. The second is a 'free-form comment' section where the user can elaborate on a solution to the issue.
Where I struggle is how to save any changes a user makes to these records. For instance if they need to change a selection from the drop down menu, or update their free-form comment, I want to update the update field for that item only.
The Update field gets updated like this:
fOSUserName() is a function used to get the user's window's login. I have this VBA line to run in the Form_BeforeUpdate event on the Form and it works fine, but only updates all records, not the record where the change was made.
Any insight on how I can limit this update to only the record that was being update would be sublime. :banghead:
I have searched for the past 1 hour and couldnt find the exact situation I am in. I will try my best to explain where I am at:
I have a form that is bound to a table that users can access to comment on specific issues pertaining to an item. Each row in the table is a unique set of data that is specific to that item number.
I have 2 fields that the user can edit. The first one is a drop-down that contains specific comments that the user can select. The second is a 'free-form comment' section where the user can elaborate on a solution to the issue.
Where I struggle is how to save any changes a user makes to these records. For instance if they need to change a selection from the drop down menu, or update their free-form comment, I want to update the update field for that item only.
The Update field gets updated like this:
Code:
Me.Last_Comment_Update = "User: " & fOSUserName() & " - Date: " & DatefOSUserName() is a function used to get the user's window's login. I have this VBA line to run in the Form_BeforeUpdate event on the Form and it works fine, but only updates all records, not the record where the change was made.
Any insight on how I can limit this update to only the record that was being update would be sublime. :banghead:
