View Full Version : Validation Rule


Haytham
11-12-2001, 12:55 PM
Hi All,
My question is bit easy.
In a form,I have a field named: Quantity, that is to be sold.
I want to sell <= the quantity I have in my store. I put the Validation rule as follows:
<=[FormNameContaining Quantity].[Form]![QuantityField], but it's giving me error that the form name is mislabelled or not exist...
Any solution to this problem
Thanks in advance

jwindon
11-12-2001, 03:37 PM
Should be


<= Forms!frmQuantityFormName!Quantity

Access will put the brackets in for you.