modify / update value of field

[Ammarhm]

HI All
I need help with something that i have been looking for for days now

If i want to look up a vlaue in a table then i use the Dlookup
Ex
DLookup("[UnitPrice]", "Order Details", "OrderID = 10248")
In this example, you would be retrieving the UnitPrice field from the Order Details table where the OrderID is 10248
What i need to do is the opposit
I need a comand where i can modify or update the value of "UnitePrice" in the table "Order Details" where the "OrderID=10248"
so it is a command like this
HYPOTHETICAL COMMAND : DUpdate("[UnitPrice]", "Order Details", "OrderID = 10248")=12 putting 12 in the UnitPrice
How do i do this guys???
I really need tis command badly, or just a way to do it...
Thanks

 

[georgedwilkinson]

DoCmd.RunSql "update [Order Details] set [UnitPrice] = 12 where OrderID = 10248;"

 

[Ammarhm]

THank you so much for the reply, really appreciate it

 

[georgedwilkinson]

NP. Always glad to help.