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 Programming / November 2005

Tip: Looking for answers? Try searching our database.

Check box on or off capability

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tony A - 28 Nov 2005 18:32 GMT
I have 7 check boxes per row.  I only want the user to check one of them.  If
the user checks checkbox1, none of the others are checked and if checkbox4 is
checked, then checkbox1 is unchecked.

Is this possible with check boxes?  Please help with the code to turn on or
off.

Thanks,
Tony
Rob Oldfield - 28 Nov 2005 19:08 GMT
There's no code required.  Just add an option group to the form and bind
that to your data field* and then add seven check boxes** to it with their
option values set to 1 to 7.

* ...assuming that you have one numeric field instead of seven boolean
fields
** ...although option buttons would be better as they fit the standard
Windows design model.

> I have 7 check boxes per row.  I only want the user to check one of them.  If
> the user checks checkbox1, none of the others are checked and if checkbox4 is
[quoted text clipped - 5 lines]
> Thanks,
> Tony
mscertified - 28 Nov 2005 19:27 GMT
You need radio buttons not checkboxes. They are designed for just that purpose.

Dorian

> I have 7 check boxes per row.  I only want the user to check one of them.  If
> the user checks checkbox1, none of the others are checked and if checkbox4 is
[quoted text clipped - 5 lines]
> Thanks,
> Tony
 
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.