I have a form which shop staff complete, I have placed a box on the form showing staff how much stock is held, this is linked to stockid so shows the stock level for the current item. I have worked out an Iif statement for saying not enough stock or stock Ok. This works well but I think I need to write it in code and attach it to the After Update event of the quantity field.
The problem is that I can't work out the code, can anyone help please?
The problem is that I can't work out the code, can anyone help please?