checkbox - strange behavior

[gmead7]

I am using MS Access 2003 (project - .adp file) with SQL Server 2000 backend.
I have a form that has several individual checkboxes. (These checkboxes are
NOT part of an Option Group).

When you create a new record and go to a certain drop down list field in the
form and make a selection, the result is that all the checkboxes on the form
become checked. I have looked for a VBA driven event that might be
responsible, but have not found any events to explain this.

Also, when you are in an existing record that has several of the yes/no
boxes checked and you want to de-select several boxes, the form will only let
you de-select 1 yes/no box and will not let you de-select the other yes/no
boxes. Again, I have not been able to find any event driven VBA to explain
this behavior.

I am looking for ideas of where else to look.

Thank you,

 

[Jeanette Cunningham]

Hi,
does this sound similar?
943967 (http://support.microsoft.com/kb/943967/) After you install Office
2003 SP3, you encounter various problems in an Access project when you work
with a Bit data type column in a linked SQL Server table

here is the link
http://support.microsoft.com/kb/945674

Jeanette Cunningham

 

[pcbins]

This 945674 "hotfix" didnt do the job for me. Is there a fix for this fix?