Urgent Access form problem

[shelbygt22]

Hi everyone,
I have a problem that I realy dont understand with one of my forms for the inventory. I use Access with SQL server, all my tables and stored procs are on my SQL db. Since last week everything works great since I add a checkbox on my form. My form as a unique table dbo.Inve and 5 subforms based on stored proc, anyway the problem is not there. I also have a command bar with button like delete, add, print and modify. When you open the form, all the fields are locked, the only way to modify a record is t click on the button Modify and then change the information you want and click OK after. My form has 2 checkbox and last week I add one more that when you click on it the field IdInventory is highlights in red with the Conditionnal Forms in the Format menu. So in grid mode I can easily see what records are affected.

The problem is that when you click on the modify button to unlock the fields and then click on one of the 3 checkbox and click OK my form is stuck(jam) on the record like he's doin a loopback. This only happen if I click on a checkbox, if I modify any of the textfields it's ok I can navigate thru other records. But if I click on one of the 3 checkbox I'm stuck on the record.

I try to delete them and re-add after, same problem. I even use my backup (2 months old, so before **** happen) same problem. Try on other PC of my workshop same ****ing problem except one that has not Active Directory install on it.

This **** is very weird it can only happen to me. All my computer here are on NT4-SP6

Please help me......................................................

Thanks !
David Roy

[Ecniv]

You say its calling itself? Is something put in the onChange event? Because that might call itself when it updates then the updated changes it and it calls itself... etc...

If its this, then you need to use a boolean on the sub so when on change is called it sets the boolean.
If it is called again whilst updating, it checks whether its true or not.
If true it does nothing. If false it will set to true, refresh/redo stuff then set to false once completed.

Otherwise, it might be something to do with your bound forms, perhaps it is trying to set the tick flag, when it shouldn't... :grasps at straws:

[shelbygt22]

It's not the onChange event but the Form_Current event that loop 2 times instead of 1 normaly. The first time, he pass with the Id of the next record to come like normal and he pass again with the Id of the modified record. Like he step forward and step back instantly.