Need help with a simple macro (1 Viewer)

[Nick.NZ]

Hi there,

I'm trying to sort out a macro so if the quantity supplied > quantity ordered, it gives an error, and won't update the quantity supplied field on a sub form with the higher number.

If the quantity supplied < quantity ordered, i want it to minus the quantity supplied from the stock level.

So far these two things work, but it'll still input the number into the quantity supplied field even if it's higher, which isn't what I want to happen

I currently have this (see screenshot 10 below). I realize im missing a command, I just don't know what it is.

any help would be appreciated.

 

[arnelgp]

on QuantitySupplied add Macro on BeforeUpdate Event:

 

[oleronesoftwares]

Another way around it is to use Field validation rules at form level , in the validation rule property of the quantity supplied field you can add <=quantity ordered