Unbound text box returns nothing

[Yam84]

I have an unbound text box, on a subform, which is located on a tab. I
have been unable to make the source of this text box return any data.
I have tried DLookup from a query:

=Dlookup("AOH","[Amt Query]","productID="& Me.productID)

I also have tried taking the field from the table it belongs to and
dropping it on the form.

I have also tried just point to it from the table:
= [Products]![prodPrice]

Nothing works.

Any suggestions?

 

[BruceM]

The Me prefix will work only in VBA. If this is the Control Source for a
text box, try:
=Dlookup("AOH","[Amt Query]","ProductID = "& [ProductID])

However, there is very likely a better way of accomplishing what you need.
AmtQuery could be in the form's Record Source, and you could bind a text box
to the AOH field. Or maybe a subform could be used. Without knowing
anything of your database's structure and purpose it is difficult to suggest
anything specific.