[RESOLVED] MS Access - Form_Current event in subform stops firing

[gigemboy]

I have a subform that has a Form_Current event wired, which is supposed to fire each time you select a different row. In the event, it is calling a Sub from the main form passing in a value from the row. This works the first couple of row selections, but then the event stops firing! Very annoying. As a test, I placed a message box in the beginning of the code to make sure the box shows up, and it does for the first couple of selections. Then nothing as I select other rows.

Can anyone explain why this might be?

[gigemboy]

It was due to disabled fields.

In the subform, I locked all the fields and set enabled to No for all fields in the form. I also had it in datasheet view. This allowed the user to only be able to select the row by clicking on the row selectors on the left hand side. However, this caused the issue I was having. Once I enabled the fields again, the Current event fired as normal. Weird how it would still fire for the first couple of times, and then nothing after that, but at least it is working now.