Awsome site! please help

[StupidStudent]

This site is a god send and really helping me understand access I dought very much if my uni project would be the same without it!!!!

There is one thing which if i could get some help with, would really make a difference.

I have a form with all the details of a plant, this also includes stock levels.

I also have a form with a customer order, where each order line specifies how many plants the customer wants.

I was wondering if it would be possible to run a bit of code that when a check stock button was pressed, it would go through and check to see if all the plants on the order where in stock?? and produce a msg box if not

PLEASE HELP !!!!

THANKS

 

[MStef]

Hello Student!

Look at "DemoStockLevelA2000.mdb" (attachment).
Open form and try.

 

[StupidStudent]

Thanks alot dude you really helped me out !!!!!