Field validation issues

[bknight]

The validation rule was implemented to prevent accidental key stroke values

Code: Select all

IIf([Type] Like "Buy*",([Quantity]>=0 Or [Quantity] Is Null) And ([QtyFilled]>=0 Or [QtyFilled] Is Null),([Quantity]<=0 Or [Quantity] Is Null) And ([QtyFilled]<=0 Or [QtyFilled] Is Null))

This code was half done not finished. It prevents a negative Quantity when a Buy* appears in the type field. What it needs is a Sell* to prevent positive Quantity, but I really got lost in all the parts and pieces. Now a new obstacle appeared when I wanted another different Type namely Expired or Assigned, mutually exclusive.

[HansV]

I hope it'll work for you!