Hi friends, is it possible to add a dlookup function in the where clause of a query? If yes, then how to do it?
I tried the following, but the line is highlighted in red indicating a compilation error starting from "Cash_Out_ID_FK" in the Dlookup.
Thank youCode:CurrentDb.Execute "UPDATE Cash_Out SET Cash_Out_Amount = " & Me!SupplyCharges.Value & " WHERE Cash_Out_ID_PK = DLookup("Cash_Out_ID_FK", "Supplies_Cash_Out", "SupplyID_FK=" & Me.supplyID_PK & "") "