Dlook up on continiouse form

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
 
D

Douglas J. Steele

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.
 
Top