I'm trying to create an Expression as Control Source for a Text Box.
An example which can be found is:
In above example the criteria is based on [ProductID] on a form.
Is it possible to change it, so criteria is based on a value from a specific query, i.e. similar as above?
I have tried something like this, but it doesn't work:
An example which can be found is:
Code:
=DLookup("[ProductName]", "Products", "[ProductID] =" & Forms![Order Details]!ProductID)
In above example the criteria is based on [ProductID] on a form.
Is it possible to change it, so criteria is based on a value from a specific query, i.e. similar as above?
I have tried something like this, but it doesn't work:
Code:
..... & Query![QRYORDER]!ProductID)