Rec. Nav. problem cause by checkboxes/Conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 !
 
Have you tried stepping through the code behind the OK button to see what
it's doing?
 
....and if that doesn't get you anywhere... then what does that code look
like? And do you have any code attached to the checkboxes?
 
No code attached to checkboxes just a conditional format expression that I
delete. I even delete the 3 checkboxes and recreate. Still have this problem
only on my pc and my boss pc. Like I said it's very weird.
 
In that case I'd suspect something along the lines of a conflict between
mdac version. There's a component checker available here
http://makeashorterlink.com/?F4AB11ABA which allows you to check that.
....and if that doesn't work, then I'd suggest posting your question in one
of the specialist SQL groups. You'll need to specify how you're linking to
the data as well, by the way, is it an adp?
 
....there again... I just found this...
http://makeashorterlink.com/?K19D21ABA

I had a similar issue with mismatching boolean fields when I wrote a .net
app to pull information out of an Oracle back end. My workaround for that
one was not to use bound checkboxes... instead I just bound the data fields
to a text box control... and then linked those controls to unbound check
boxes using the current event of the form (to set the check boxes
appropriately) and the after update of the checkboxes (to write the correct
values back into the bound fields). Very messy, but at least it worked.
 
Back
Top