Validation rule with SQL ?

[AlexandreAmant]

Hi !
I am building a stock database and I have a combo in which the user chooses the product he wants to order and the quantity in stock for that chosen product appears in a listbox (could not find an other way).

The user then can put in a text box how many pieces he wants to order.
I want to do a validation rule that checks that the user does not order more than what is in stock. I have put some SQL in the validation rule and it tells me that there is no current record in the validation rule of the object.

Anyone can help ?

 

[mp9]

Rather than using a validation rule, use VBA in the text box's AfterUpdate event to ensure that everything is hunky-dory.

http://www22.brinkster.com/accessory/