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...
The rowsourse of the combo box is a separate table called EVENT_LIST that has the listing of all the events. The key field aka the Event Type ID number is hidden in the combo box selection. The Pastoral Calling event ID number is 9.
I am creating a database for a church. In my event form I have a combo box that will allow the user to select the various events the church is involved in. One of those events types is called Pastoral Calling and with that specific event the pastor needs to keep track of his mileage for...