Unbound controls on a form

Combine the 2 into one string.

strFilter = "(ProductID = " & Me!ProductID & ") AND (TierID = " & Me!TierID
& ")"

Then end result has to look something like the WHERE clause of a query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Megan" wrote in message
...
Can you send conditions in a DLookup?
Northwind uses:
strFilter = "ProductID = " & Me!ProductID
Me!UnitPrice=DLookup("UnitPrice", "ProductsPrice", strFilter)

How can I modifiy this to send the price tier?
I've had trouble finding information on DLookup.

So I need something like:

strFilter = "ProductID = " & Me!ProductID
priceFilter = "TierID = " & Me!TierID
Me!UnitPrice=DLookup("UnitPrice", "ProductsPrice", priceFilter, strFilter)

Can you send extra parameters?

That makes compete sense. I'll try it. Thank you.