Check Box Validation Rules

[EgoT]

Hi,
This is what my problem is: I have 3 Check Boxes what I want to do is get it so that when one box is ticked then the other two boxes cannot be ticked.

The code I'm currently using is: "IF [Maunal Wheelchair] True And [Powered Wheelchair] «Expr» False «Expr» AND [Powered Scooter] False"

I've tried IF THEN and IF ELSE, but as yet I have had no joy whatsoever as each time I check to see if I can tick a box I can tick the other two boxes but not the one that should be ticked. And if I try and tick that box or exit while I have another two boxes ticked or unticked then it comes up with a message stating: &quot;One or more values are prohibited by the validation rule...<<insert rule that's above here>>...Set for 'tblShopmobility.Manual Wheelchair'enter a value that the field will accept.&quot;

Any help would be greatly appreciated!!

 

[Darrylles]

Hi Ego,

Why not use an Option Group? (Looks like a frame with XYZ at the top). When you choose this, you are prompted for fields etc.
It'll handle your problem effectively.

If not, then reply - I've got email notification set.

Regards,

Darrylle


&quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot;