Validation Rule

Haytham

Registered User.
Local time
Today, 16:57
Joined
Jun 27, 2001
Messages
162
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
 
Should be


<= Forms!frmQuantityFormName!Quantity

Access will put the brackets in for you.
 

Users who are viewing this thread

Back
Top Bottom