Ms Access inventory system, issuing form

[rajsal]

Dear all
I have trying to to create an inventory system using Ms Access (office xp) , i have a problem in issuing an item from the stock available.

I have a query which calculate the stock available in stock.

What i want is the user not to issue the items more than available in stock (that is the balance in a query).

How can i write a validation code which can go and read balance in query and compare with the amount intered in quantity field of issuing form.

Thanks all
I am waiting an answer

[Allan Murphy]

Just a suggestion as I have not tried this.

Create an unbound text on your form with the query as your record source. Then use code similar to below, for this exercise we use issue_qty for the quantity to be issued and the unbound control we will call product_balance..

if me!issue_qty> me!product_balance then
display a suitable message etc and other relevant code
end if

You could look at the Inventory sample in Access

Allan