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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

continiuse form with text Box - Data apears in every one not just one 1
message box with D look up 1
Dlookup turn -1 or 0 into a word 2
Speed up Querys 1
Using VBA to change background color of a field on a form 2
Product SEarch Form/ Query 1
Unbound text box returns nothing 1
search form not to load all data up to start with 1

Back
Top