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 - 29 Feb 2008 23:04 GMT
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
>I am using MS Access 2003 (project - .adp file) with SQL Server 2000
>backend.
[quoted text clipped - 20 lines]
>
> Thank you,