Check the stock before making the order

[nadoona]

Hi,
I've a form used to add new orders (from the OrdersTable) containing a subform for order details, such as the item No, quantity, and unit price (from the OrderDetails table). I'm wondering if there is a way to check the current stock of an item while making the order to make sure that the quantity in the order doesn't exceed the stock. Note: the Current Stock of an item is a field in the ItemsTable.
Thanks in advance.

 

[RichO]

Try using DLookup. The Access Help file explains it well and you can also find more information searching this forum.