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
|
|||
|
|||
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
|
|||
|
|||
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 |