Vesubius_101
New member
- Local time
- Today, 09:47
- Joined
- Jul 7, 2009
- Messages
- 2
This probably sounds like a real newbie here. I have a date field on my main form that I want "disabled" after initial entry. For example, my accountants will go into the field called "Assigned Date" and type "May 31, 2009", next month, they will go back to the same record and change the date to "June 30, 2009" to make their stats look better. BTW, I'm using MS Access 2003.
I understand that by using VB code, I can adjust the properties of the field so that when the field is initially updated in a new document, it will allow for a date to be entered, but "AFTER" initial data entry, the field will remain disabled and no modifications will be allowed. I right click on the field to the the properties dialogue box. Under the "Event" tab, I see the line that says "After Update" and I believe that's where the VBA code would go. Does anyone know the code?
I understand that by using VB code, I can adjust the properties of the field so that when the field is initially updated in a new document, it will allow for a date to be entered, but "AFTER" initial data entry, the field will remain disabled and no modifications will be allowed. I right click on the field to the the properties dialogue box. Under the "Event" tab, I see the line that says "After Update" and I believe that's where the VBA code would go. Does anyone know the code?