Validating data on Calculated Control

[ayo]

Hi, I need to validate data on a calculated text box control on my form.I've used validation rule property of the text box but it didn't work.Pls help me out

 

[RV]

1) more info, what have you done so far?
2) it's more logical to validate on the
the data the calculation is being based on......

RV

 

[ayo]

Thanx for the reply RV. I have a textbox(balance) that calculates data based on two other textbox(quantity allowed & total quantity requested). I needed to be able to restrict the quantity requested (the value in balance textbox should not be less than 1).I tried to validate the value in the balance textbox using validation rule property.I've attached some VB code to the On Change event procedure of the balance textbox but it's not working.I hope this explanation will help in solving this problem
AYO

 

[IfButOnly]

It should work as RV has suggested in his second point.

Put your validation rule in QuantityRequested

<[Balance].value - [xxx].value (or whatever)