Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / February 2008

Tip: Looking for answers? Try searching our database.

checkbox - strange behavior

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gmead7 - 29 Feb 2008 19:02 GMT
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,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.