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.
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.