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

Sorry to hear about NT4. What's up with that?

Anyway, the problem is on the SQL server. I had this happen to me and couldn't resolve it. It may be related to new fields added to the SQL back end. If you are using an old front end, you still have this modified back end.

The way I solved it was to downgrade a portion of the SQL database to an Access back end.

I suggest you make this same post on the SQL forums, and emphasize the changes you made to the SQL back end in order to imeplement this change. Then repost here with the solution.

HTH

mmcdonal