ARGH! I hate Access!!!

[Shul'Zan]

Please help me out there, or I'm soon gonna throw my pc by the window!!! Alright, I'm in the basement, but whatever. So here's the deal: I made a from based on a table named Donateurs (that's in french). At the top of the detail section, I put a combo box listing the primary key of the table Donateurs.I managed to get it display all the corresponding record's info in text boxes when you enter a code. Up to now everything's fine. What pisses me off is that I regularly have to scrap the form altogether because that stupid combo box suddenly stops working, i.e. either it doesn't recognize the click event anymore or the other controls don't update.

If you have any kind of advice please tell me, for the sake of my computer!!

 

[Shul'Zan]

Nevermind, 'found the answer by myself.

 

[L15a5]

So what was the answer? As I have encountered the same problem.
Lisa

 

[Shul'Zan]

I don't know if everything I'll say is exact, but that's my guess of why it does that. It's something about the control names. I found in the code section that my combo box had more than one identical entries that referred to different controls. Perhaps I renamed, deleted or replaced them, so that now the same combo box has several sections of code attached to it. What I did is delete the parts of the box's code that were related to the wrong controlnames, if there were any, and I altered the topmost one so that it fits with my current set of controls names. But I did worsen the situation by deleting the form altogether and creating a new one with the same control name for the combo box. DOn't do that, as the other controls on your form will have new names and it will add more and more code to the form, which will mess things up even more. *shrugs* I hope this helped!