TRACK CHANGES WITH USERNAME & TIME STAMP

[ARW17]

Hi! I have a table that I put into a subform so users can fill out portions of the data. The user will review the work and write in who is responsible, the credit category, cause, and notes. I want to hide the TINITIALS (username) and STAMP (time stamp). I want to use an Event, but I can't figure out where to put it. I want the TINITIALS and STAMP to change whenever someone changes something they're able to fill in. Do I want to be on the property sheet for the specific text box (like RESPONSIBLE) or do I want to be on the property sheet for the subform? And then where do I put the VBA? I've read examples of Before Update, Before Insert on the subform or On Change on the text box itself, but none are working. My plan was to use this code once I found the right place. Can you confirm whether it's right or not too?

Me!TINITIALS = Environ("username")
Me!STAMP = Now()

My subform's name is E_ENTRY_GRADE_CRED_SUB. Do I use that instead of Me!?

Thanks in advance! You guys have really come through for me in the past!

 

[Micron]

I don't think you can change a textbox into a checkbox on any form. Resize the textbox, move it out of the way, manually add a checkbox and bind it to the same field and see what you get.

 

[xenou]

Yes agree with Micron if you don't have the option to change it with right click magic then you have to remove the textbox control and add a checkbox control the old fashioned way ...