DLookup on continuous form

[Costefran]

Please ignore my previous conditional formatting problem as I have now resolved it

I have a new problem as follows

I am using a Dlookup on my [Clash or Not] Control on a continuous form. The Dlook up looks up a query and sets the results for all text boxes on all records, despite the fact that the Dlook up query has a parameter set to the value of a control in each record

Please note that there are 3 records
1 should show an actual value based on the Dlookup
The other two records should not have a value as the underlying query does correctly not provide a result for these
However, every control on these records shows the same value for all

Hope this makes sense

 

[TheAceMan1]

Costefran . . .

Are you referencing the control in the query?

Post the SQL!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Costefran]

thanks for the response. I think the answer is no to explain

I have 2 queries called A Subform and B DLook up

Query A provides a number of results on which the subform is based

Query B filters Query A that produces only those results of Query A that satisy a parameter (not sourced from the subform)

 

[MajP]

Provide the SQL for the queries, and the dlookup code.