If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Rec. Nav. problem cause by checkboxes/Conditional formatting
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 to 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 Conditional Formatting 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. In debug mode, on the Form_Current event he pass 2 times instead of one normally. The first time he pass with the IdInve of the next record like usual and then he pass again with the IdInve of the rec that I modifyed. And like I said previously he only do that if I click on one of the 3 checkbox. If I modify anything else its ok. On my other forms, if I modify a checkbox its ok too. It's only that ...... form who have this problem. I try to delete them and re-add after, same problem. I even use my backup (2 months old, so before this ... happen) same problem. I try the /Decompile and I still have the problem. Now I will try in design mode to delete all of the existing Conditional Formatting in the Wizard to see if it could work. But one thing still bizzar to me, why only me and my boss have this problem, what do we have in common that make this thing happen. My boss run winXP and me NT4 SP6. Still searching for solutions. This is very weird it can only happen to me. All my computer here are on NT4-SP6 Please help me................................................ ...... Thanks ! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Strange problem with different networks. | Adam | General Discussion | 1 | March 13th, 2005 10:17 PM |
IE6 & Outlook Problem (Strange Problem)! | KW | Outlook Express | 4 | February 1st, 2005 08:31 AM |
Reinstalling OE... | KAR | Outlook Express | 24 | August 21st, 2004 06:52 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
Fromatting Problem w/ Document Created in Works | Inky | Formatting Long Documents | 2 | May 4th, 2004 04:22 AM |