Dsum problem !

[andrep]

I am using an update query to show the quantity of orders!
Table products ProdId (key field)
Table order details¨ProdId (key field) also lookup field bound column1 column count 2.

The problem i have is that the bound column is 1 in the table with a column count of 2 to show the description needed for the order detail description!

now my dsum is looking at the description rather that the
id of the row!

so i am trying to use
DSum("[Quantity]","Order details","[ProdID].column (1)= " & [ProdId])
I have tried various ways to write the syntax without any satisfactory results!

Does anyone know a work around for this problem !

Thanks

 

[lameid]

Assuming ProdID is your bound column,
DSum("[Quantity]","Order details","[ProdID] = " & Me![ProdId])

If the second column is bound and the name of your control is cboProdID,

DSum("[Quantity]","Order details","[ProdID] = " & Me!cboProdID.column(1))

 

[andrep]

Sublime !

Thanks you lameid !