Validation rule in Form

[Vugar]

Hi,

I have "Outgoing" form in StockDB.

in "Outgoing" Form in "Quantity" field I set validation rule:<=Nz(DLookUp("[SumOfQuantity]","[TotalInStock]"," ItemID = " & [ItemID] & "And [Status ID] = " & [Status ID]),0)

and when I did not fill out "StatusId" there is an error (see attached). Can I change the text of the error to "You have entered StatusId"

Thank you.

 

[plog]

Look at that error message closely. You are missing some spaces between keywords.