Access 97

C

Chris waller

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

John Vinson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Style to 'Keep with previous' instead of Keep with Next 1
Creating a checklist with predefined comments 1
Creating a check sheet - to include paragrpahs or remove paragraphs 1
Word 97 Password 0
Help creating a search form in Access XP 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Word VBA - Want to test if Full Name is NOT Present in document 0
No option to create a list in SharePoint Site 0

Top