I creating a Consumables Database for Printer Toners to book in and out and amend stock.

The tables I have are:
Consumables
Printers
Location
Orders
Compatibility
Purchased Consumables

I am trying to create a query where the Purchased Consumables form is taking the stock number from the Consumables table and places this into the field "lblCurrentStock".

I have written this in SQL:
SELECT tblConsumables.QuantityStock
FROM tblPurchasedConsumables INNER JOIN tblConsumables ON tblPurchasedConsumables.luCurrentStock=tblConsumab les.QuantityStock
WHERE ((([Forms].[frmPurchasedConsumables].[cmbConsumableName].[Value])=[tblConsumables].[ConsumableName]));

But it does not return anything.

Thanks
Edd