Unchecking Checkboxes using ADO Recordset

[Toga]

I have a form bound to an ADO recordset with several checkboxes on it. I can check them all with no problem, but I can only uncheck one of them.

In order to uncheck another checkbox, I either have to do a me.refresh or leave the record and come back to it.

All the text fields and dropdowns are acting normal.

Anyone ever have this problem, or have a work around short of having to put a me.refresh command after each checkbox is updated????

 

[PHV]

I can check them all with no problem, but I can only uncheck one of them
How do you do that both things ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Toga]

Sorry, I wasn't clear.

I have a form bound to an ADO recordset with six checkboxes on it. I can check them all with no problem but let's say I screwed up and needed to uncheck 3 of them. I can uncheck the first one but I cannot uncheck the other 2.

I either have to do a me.refresh or leave the record and come back to it....and then I can uncheck one more box.
Do it again to uncheck the other box.

I only see this issue when the form is bound to an ADO recordset. If I don't use ADO and just set the forms record source properties to the same table, no problem.

Hopefully this is more clear.

It feels like those bit (yes/no) fields are not updated the same way with ADO....I just don't know.

 

[PHV]

Again, what is your actual code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Toga]

Here's the code I'm using to bind the form to the ADO recordset.

Set rs = New ADODB.Recordset
rs.Open xsql, ISODBC, adOpenDynamic, adLockOptimistic


Set Me.Recordset = rs

 

[jarico75]

I am having the same issue. Did anyone respond to this post or did you figure it out?

 

[Toga]

Hi Jarico75,

No I never did figure it out. To get around it I had to include a me.refresh each time a check box was clicked. Very hoakie but it worked for what I needed.

Let me know if you have any better luck.