Problem with Dlookup(

[matt17]

Ok well I have been successful so far in not asking questions, but I
have hit a stumper for me this time. I have a catalog report. Sometimes
a catalog requires another catalog to be purchased so out of simplicity
I show both catalogs in the same section with the prices... i.e.
Lpxh234 $23
092j2j2j $15

normal section would be:
L2eh234 $13

My only problem is I can't figure out the syntax or how to put the $15
there. What I have to so far is I setup an unbound text box named
"txtEach", also I setup a query that puts the required catalog and the
price
Name: qryRequiredEach
SELECT tblRequired.rqdCatalog, tblProducts.Each, tblProducts.Required
FROM tblRequired INNER JOIN tblProducts ON tblRequired.rqdAutoID =
tblProducts.Required;

Well I am not sure if I have said enough information, but this is
driving me nuts so any help would be greaty appreciated

 

[matt17]

My problem with Dlookup which I should have said my last message, was
that I can't figure out how to set it up correctly. I have tried many
things but all just don't show me anything.
This is the syntax I am trying to follow:
Control Source=DLookUp("field name in query","name of query","[field in
query]=[field on report]")
and here is how I set it up:
Control Source=DLookUp("[Each]","qryRequiredEach","[Each]=" & [txtEach])

 

[matt17]

Heh, well I feel like an idiot... it helps if you set visible = true
and I had a totally non-working example shown.
Thanks, for not responding