DLookup criteria

[mypeljo]

On my form i want to build a dlookup control looking for the code in the query "QryProductSales" with the crieria called code.I have the control code in the form and i want to look up for the data with the corresponding code in my query.I have built partly the control but i could not define the criteria, they should be as follows : where code in the form is equal to the code in the query. Can you help me ?
My following control has no criteria and cannot work:
="Sales: " & "" & DLookUp("[Bought]";"QryProductSales") where ........?

 

[Gruuuu]

There's no 'where'. Try this

="Sales: " & "" & Dlookup("[Bought]", "QryProductSales", "[Product] = '" & controlName.Value & "'" )

[green]'or if it's by ProductID or similar situation[/green]

="Sales: " & "" & Dlookup("[Bought]", "QryProductSales", "[ProductID] = " & controlName.Value )

 

[mypeljo]

excellent! Thank you very much !