Access 07 - Getting info from a table to use in a form

[edd]

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=tblConsumables.QuantityStock

WHERE ((([Forms].[frmPurchasedConsumables].[cmbConsumableName].[Value])=[tblConsumables].[ConsumableName]));

 

But it does not return anything.

 

Thanks

Edd