Sorry my title is general the problem is i know what i want my table to do but i don't know what its called or how to do it!!
I work in a school and am setting up a database of gifted and talented children along with their care information. My table has headings such as 'Student name', 'Tutor group', 'Nationality', and then 'Gifted and Talented'.
Gifted and talented is a tick box option and what i want to happen is that when i tick the gifted and talented box for a student i then want the list of subjects to come up so i can tick which ones they are gifted and talented at. i have set up a subjects table listing them all as i thought that would be needed but now i am stuck!

Sorry if this is a simple one

Thank you
Sam

create an After Update event for the tick box and test its current value.

if me!myTick then
' if true
else
' if false
endif