|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 17th, 2004, 09:03 PM
|
|||
|
|||
Access 97
I have created a table in access, and in the table there are two tick boxes.
Once one of the boxes is ticked I would like the other disabling. Any help would be appreciated. 
|
|
#2
November 18th, 2004, 07:22 AM
|
|||
|
|||
|
On Wed, 17 Nov 2004 13:03:07 -0800, Chris waller
wrote: I have created a table in access, and in the table there are two tick boxes. Once one of the boxes is ticked I would like the other disabling. Any help would be appreciated. You cannot do this in a Table; tables have no usable events. You can do it with some VBA code on a Form. The fact that the second Yes/No field depends on the value of the first indicates that your table structure does not meet third normal form: fields should depend only upon the table's Primary Key, not upon one another. What is the nature of the data that requires this? John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
| is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |
| Data from Excel to Access | Database Design | 2 | August 20th, 2004 12:53 PM | |
| Useless Access 2003 | tired, angry, sucidial and bored | General Discussion | 10 | July 21st, 2004 11:52 PM |
| You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |
Linear Mode
