Tickbox Question

[jo15765]

Is it possible to set it to where if tickbox1 is checked then EITHER tickbox2 OR tickbox3 has to be checked? I am not sure how to set this one up, I think a SQL OR statement would do it, but I am not familar with SQL.

[ajetrumpet]

on the click event, issue conditionals. that would be easiest. it would be even easier if you had an option group with all of the boxes in it. Because you can specify in the property sheet whether you allow one or multiple values. That way, Access does most of the legwork for you. Code is hardly ever needed in that scenario.

[jo15765]

i was thinking of the onclick event but i couldn't figure out how to use an or statement. i know how to do an if/then, but have never used an or. the options group sounds like an interesting approach, i am going to research this one and find out more!

[ajetrumpet]

i was thinking of the onclick event but i couldn't figure out how to use an or statement. i know how to do an if/then, but have never used an or. the options group sounds like an interesting approach, i am going to research this one and find out more!

it's a control, jo. the option group is a control. basically, it takes more than one control, groups them together, and assigns long values (1,2,3,etc...) to the group object, based on what control is selected. this is best. seriously cuts down on code writing need too.