populate unbound text

samjesse

Registered User.
Local time
Today, 04:01
Joined
Feb 13, 2009
Messages
64
Hi

I have a Continuous Form with an Unbound TextBox, its Data property has
=DLookUp("price","tblPrices","SupplierID = 1" And "ItemID = [itemID]")
The form Data is based on tblItems

I am getting one price for all the records. I expect to get the correct price for each item.. Please help.

Thank you.
 
Unfortunately Continuous Forms do not work well with Unbound Text Boxes..
 
Unfortunately Continuous Forms do not work well with Unbound Text Boxes..

I changed it to Single Form for no avail.
How can I overcome this problem?

thx
 
I hope Item ID is numeric..
Code:
= DLookUp("price","tblPrices","SupplierID = 1 And ItemID = " & [itemID])
 

Users who are viewing this thread

Back
Top Bottom