Dlook up on continiouse form

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I have a continiouse form showing lots fo products, i want to put a
field that shows strock leve
I have but the following code in the on load
StockLevel = DLookup("StockLevel", "qryStock", "ProductID = " &
Me.ProductID)

However as its a continiouse from its shows the same stock number for
all product, how do i do it that it looksup stock for each prodcut
indivedual


Thansk
 
When you set an unbound textbox like that, all instances of the text box
will get the same value.

You'll need to create a query that returns the stock level along with the
rest of the fields you need for the form, and use that query as the form's
RecordSource.
 
Back
Top