I have a form called Jobs on that form I have a sub form Parts.
As i enter part numbers each one returns a status for that part. ie: in stock, no stock or on order.
What I want to do is look at all the parts and return a result if they are all in stock so that I can then use that to change the status on my main form to Job ready.
I need a code that will look and them all and return a result
As i enter part numbers each one returns a status for that part. ie: in stock, no stock or on order.
What I want to do is look at all the parts and return a result if they are all in stock so that I can then use that to change the status on my main form to Job ready.
I need a code that will look and them all and return a result