Quantity ordered

[kabir_hussein]

Hi i am trying to do a testing feature on my form where the user can not alter a order and make the new figure lower than what has already been ordered.

At present i am using this calcualation

>=[Orderammended1].[Form]![Text22]

but if a order has not been delivered the quantity delivered is 0 but if change the order level it doesnt allow me.

What code can i use for the field to accept 0 for the quantity delivered.

many thanks

 

[dcx693]

When you try to enter 0 into the field, what value is currently there? Is there a Null value? Meaning no entry at all?

A way around this problem is setting the default value of the field to 0, and updating the blank entries to 0 with a query. It depends on how you want to handle items not yet delivered.

 

[kabir_hussein]

Hi

At present there is a 0 default value however the Total delivered field is a calcualtion field. the quantity ordered is say 5 for a example. and for whatever reason the order will now be changed to 9.

if i change the quantity delivered to 9 then my error message pops up.

the Total delivered is blank if nothin has been delivered.

thank you

kabir