Creating Multiple Validation Rules For Forms

[MaxLev]

Hello,

I am attempting to create a form for data entry for a large supply company. The purpose would be to have fields that people can enter data into about the product they are currently looking at. There will be many fields including a field for 'Master Pack Weight' and 'Sell Pack Weight', among other similar to this. I would like to create a validation rule for 'Sell Pack Weight'<='Master Pack Weight', as well as 10 or so other rules that govern other relationships so mistakes are not entered into the form.

I can't seem to figure out how to create multiple validation rules. Can someone assist?

Thank you,

Max

[alansidman]

I believe that you will need to create these rules using VBA employing the IF-THEN-ELSE syntax. Probably need to do it in the afterupdate event for the control you wish to validate. If it does not meet criteria, then have a message box open indicating an issue.

Here is a link on the syntax.

http://www.techonthenet.com/access/f...ed/if_then.php


Alan