DLookup Function with Query

[djwasim]

hi every one


i have some problem when i use Query in DLookup Function As a refrence instead of Table

For Example

i am using this.....

=DLookUp("Item_Rate","Query","Party_ID =" & [Forms]![Transaction]![Party_ID] & "And Item_Colour = " & [Forms][Transaction]![Colour]),""")

Here i want to update the rate of an item in a Query where Party ID and Item Colour are matching with the fields in form

there is a Query Named "Query" like this

Party_ID___Party_Name_______Item_Name____Item_Colour____Item_Rate
1101______Jhonson & Co._____Shoes________Black____________85
1102______Malie Brothers_____Shoes________Brown___________76
1103______Sampson Brothers__Shoes________White___________90
1101______Jhonson & Co._____Shoes________Off-White________72


in the form named "Transaction" i want to put Customer/Party ID like "1101" in party id field and also item Name Like "Shoes" and also Item Colour Like "Off-White" and want to get Item Rate Rs. "72" instead of Rs.85 because the parties are the same but item rate is different

i Will b thankful to everyone if solve this problem

 

[djwasim]

Please Help Me