Access 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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