Hi, I was wondering if anyone could help me. I have a form that contains a maximum of 20 records at a time. Each record has a yes/no field, but I want to limit the number of yes/no that can be ticked. At the moment, I have an IIF calculated field named SelectValues that assigns a 1 or a 0 depending on whether the yes / no is ticked or not. I then have a a calculated control that sums the number of SelectValues.
I have tried to code this through VBA without success. I used an IF function within the code builder for the before update event in the yes/no field property (see below).
if(text18>5) then
msgbox(....)
Cancel = True
Am I on the right lines or is there another way of doing this?
I have tried to code this through VBA without success. I used an IF function within the code builder for the before update event in the yes/no field property (see below).
if(text18>5) then
msgbox(....)
Cancel = True
Am I on the right lines or is there another way of doing this?