Something tells me that using the event name ID would be simpler. Simple code is good code I always say.
Alansidman, I used your suggestion on enabling and disabling fields rather than locking them. It looks a lot better.
This is a great forum. This is my first attempt at using VBA in a access...