Unusal Action in MS Access Database

[Dominick Marciano]

I'm hoping this is the appropriate board for my question. If not I apologize in advanced. My company is using MS Access to store all certificates we issue. Part of the form consist of a combo box with all the inspector names and then a text box next to it with there license number. I wrote some code so that when an inspector's name is selected it first checks if their license is expired. If it is, it displays a warning message. If it's not expired, it then places their license number in the text box. Everything was working fine. However, now when a user opens the form, if the first thing they do is change the combo box to a different inspector, the VBA code with opens up and breaks at the first line of code. If the code is let to continue, it will not break again until the database is reopened. Now, if any other field is changed first, and then the inspector's name is changed the code does not break. Why is the code breaking only on this subroutine and only if it is the first field changed? There are no break points set, and I couldn't find anything in the properties windows and nothing online. Any help would be greatly appreciated as I'm at a total loss of what to do.

[David Mujica]

Could you post the code for the event handler ? Is it the On Change Event ? Also post the exact error message that is being displayed. I'm guessing that there is a reference to something that is not initialized which is causing the error. I'll do my best to help you.